Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

making a field equal a specific number

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

View solution in original post

1 Reply
Miguel_Angel_Baeyens

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