Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the status column with the NULL,-,A,B values. But I want to show always only data of STATUS value 'A'.
How to filter or show?
Thanks in advance.
Script:
SALTable:
load *,date(DATE) as Date,
month(date(DATE)) as Month,
'Q' & ceil(month(date(DATE))/3) as Quarter,
year(date(DATE)) as Year;
LOAD * INLINE [
EMPNO,ENAME,JOB,INCHARGE1,INCHARGE2,DATE,SAL,DEPTNO,STATUS
7369,SMITH,CLERK,7902,7566,17-Dec-2015,700,20,A
7369,SMITH,CLERK,7902,7566,17-Dec-2015,900,20,A
7499,ALLEN,SALESMAN,7698,7839,20-Feb-2015,1600,30
7499,ALLEN,SALESMAN,7698,7839,20-Feb-2015,1900,30
7521,WARD,SALESMAN,7698,7839,22-Feb-2015,0,30
7521,WARD,SALESMAN,7698,7839,22-Feb-2015,1650,30
7566,JONES,MANAGER,7839,7698,2-Apr-2015,2975,20,A
7566,JONES,MANAGER,7839,7698,2-Apr-2015,3975,20
7654,MARTIN,SALESMAN,7698,7788,28-Sep-2015,1250,30,A
7654,MARTIN,SALESMAN,7698,7788,28-Sep-2015,2250,30
7698,BLAKE,MANAGER,7839,7698,1-May-2015,2850,30,A
7698,BLAKE,MANAGER,7839,7698,1-May-2015,3850,30,A
7782,CLARK,MANAGER,7839,7566,9-Jun-2015,0,10,B
7782,CLARK,MANAGER,7839,7566,9-Jun-2015,3450,10,B
7788,SCOTT,ANALYST,7566,7782,9-Dec-2015,1250,20,B
7788,SCOTT,ANALYST,7566,7782,9-Dec-2015,4000,20,B
7839,KING,PRESIDENT,NULL,7698,17-Nov-2015,5000,10,A
7839,KING,PRESIDENT,NULL,7698,17-Nov-2015,6000,10,A
7844,TURNER,SALESMAN,7698,7788,8-Sep-2015,1500,30,B
7844,TURNER,SALESMAN,7698,7788,8-Sep-2015,2500,30,B
7876,ADAMS,CLERK,7788,7698,12-Jan-2015,1100,20,B
7876,ADAMS,CLERK,7788,7698,12-Jan-2015,2100,20,B
7900,JAMES,CLERK,7698,7566,3-Dec-2015,950,30,-
7900,JAMES,CLERK,7698,7566,3-Dec-2015,650,30,-
7902,FORD,ANALYST,7566,7782,3-Dec-2015,3000,20,A
7902,FORD,ANALYST,7566,7782,3-Dec-2015,2000,20,A
7934,MILLER,CLERK,7782,7782,23-Jan-2015,1300,10,A
7934,MILLER,CLERK,7782,7782,23-Jan-2015,300,10,A
];
If you want to filter in the load script:
LOAD * INLINE [
...
] WHERE STATUS = 'A';
Or select A in your list box and then use lock option in list box properties. This will keep all records in your data model, so you can change your mind on the fly.
If you want to filter in the load script:
LOAD * INLINE [
...
] WHERE STATUS = 'A';
Or select A in your list box and then use lock option in list box properties. This will keep all records in your data model, so you can change your mind on the fly.
Thank you swuehl.