making a field equal a specific number

Mon, 23 Aug 2010 12:34:59 GMT

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

making a field equal a specific number

Miguel_Angel_Baeyens — Mon, 23 Aug 2010 13:16:31 GMT

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

topic making a field equal a specific number in QlikView

making a field equal a specific number

making a field equal a specific number