Discussion board where members can get started with QlikView.
I am pulling all fields from a table in Access, and I tried to add a Load command to the script to create an additional field.
The table has Code1, Code2, etc. thru Code6, and if any of these begins with an "M" I want a boolean field to be True.
When I run this script I get the fields from the table, but not the additional field Flagged. Can anyone tell me what I need to add? I could do it in the Access table first, but I'd like to learn how to do it here, since this field would be used for a chart.
Solved! Go to Solution.
Put the load statement on top of the select statement.
change it so it will look as follows:
Load *, //that way you load all data from the SQL statement
if(.........) AS flagged;
from 'table' ;
You can use it with 'True' so it will be a string or either put 1 instead,
If (condition,1, else..)
ב-14 בדצמ 2012, בשעה 00:24, "Bill Ritzel" <email@example.com<mailto:firstname.lastname@example.org>> כתב/ה:
Re: Load command in script syntax
created by Bill Ritzel<http://community.qlik.com/people/billritz> in New to QlikView - View the full discussion<http://community.qlik.com/message/291492#291492>