topic Re: How to load using where and order by in QlikView

How to load using where and order by

Wed, 04 Jun 2014 11:37:27 GMT

i want to load a column emp_name from a table employees using order by and where clause.

where emp_id is 1,2,3.

orderby emp_id.

i need to load this through script

Re: How to load using where and order by

nagaiank — Wed, 04 Jun 2014 11:40:14 GMT

Use

Where Match(emp_id,1,2,3) > 0

Order By emp_id

Re: How to load using where and order by

tresB — Wed, 04 Jun 2014 11:44:58 GMT

Yes, possibly she was asking for where part. '>0' part is redundant here, try like:

Where Match(emp_id,1,2,3) Order By emp_id

Re: How to load using where and order by

satishkurra — Wed, 04 Jun 2014 11:47:25 GMT

Use this

LOAD EMPNO,

ENAME,

JOB,

MGR,

HIREDATE,

SAL,

COMM,

DEPTNO

Where Match('EMPNO', 1,2,3);

SQL SELECT *

FROM SCOTT.EMP

Order By EMPNO

Re: How to load using where and order by

its_anandrjs — Wed, 04 Jun 2014 11:51:52 GMT

Try With this

tmpSource:

Load

emp_id

From Location;

Noconcatenate

FinalTable:

Load

emp_id

resident tmpSource

where Match(emp_id,1,2,3)

order by emp_id Asc;

Drop Table tmpSource;

Re: How to load using where and order by

Wed, 04 Jun 2014 12:09:35 GMT

it is showing script syntax error in orderby emp_id Asc;

Re: How to load using where and order by

its_anandrjs — Wed, 04 Jun 2014 12:13:22 GMT

Put space between Order By

Eg:-

Order By emp_id Asc;

Re: How to load using where and order by

Wed, 04 Jun 2014 12:39:19 GMT

i tried after loading it is showing garbage statement after non concatenate

Re: How to load using where and order by

tresB — Wed, 04 Jun 2014 12:45:42 GMT

Could you post your script piece?

Re: How to load using where and order by

vardhancse — Wed, 04 Jun 2014 12:48:09 GMT

we need to keep the where condition after mentioning the table name .

Re: How to load using where and order by

its_anandrjs — Wed, 04 Jun 2014 12:50:07 GMT

Try with this

tmpSource:

Load

emp_id

From Location;

Noconcatenate

FinalTable:

Load

emp_id

resident tmpSource

where Match(emp_id,1,2,3)

order by emp_id Asc;

Drop Table tmpSource;