making a field equal a specific number

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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