Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
This is what i want my Qlikview program to say but how do i write it in the proper syntax as below is not the way
LOAD
PROJECT_ID = 'S07050720',thanks
Hello,
Do you mean you only want to load all those records where field PROJECT_ID equals to 'S07050720'? If so, you can use the WHERE statement in either LOAD or SQL SELECT statement
Table:LOAD Field;SQL SELECT Field FROM DatabaseTableWHERE PROJECT_ID = 'S07050720';
But if what you want to do is to create a new field called PROJECT_ID where its value is always 'S07050720', you may do as following
Table:LOAD *, 'S07050720' AS PROJECT_ID;SQL SELECT *FROM DatabaseTable;
Hope that helps
Hello,
Do you mean you only want to load all those records where field PROJECT_ID equals to 'S07050720'? If so, you can use the WHERE statement in either LOAD or SQL SELECT statement
Table:LOAD Field;SQL SELECT Field FROM DatabaseTableWHERE PROJECT_ID = 'S07050720';
But if what you want to do is to create a new field called PROJECT_ID where its value is always 'S07050720', you may do as following
Table:LOAD *, 'S07050720' AS PROJECT_ID;SQL SELECT *FROM DatabaseTable;
Hope that helps