Discussion Board for collaboration on QlikView Scripting.
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.
i need to load this through script
Where Match(emp_id,1,2,3) > 0
Order By emp_id
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
Where Match('EMPNO', 1,2,3);
SQL SELECT *
Order By EMPNO
Try With this
order by emp_id Asc;
Drop Table tmpSource;
it is showing script syntax error in orderby emp_id Asc;
Put space between Order By
Order By emp_id Asc;
i tried after loading it is showing garbage statement after non concatenate
Could you post your script piece?
we need to keep the where condition after mentioning the table name .