LOAD & SELECT

[wanyunyang]

If in qlik sense data load editor, I do:

LOAD A+B AS X,Y;

table1:

SELECT A,B,Y FROM... WHERE...;

Then what would the fields in table1 be? A,B,Y or X,Y?

Thanks in advance!

[sasiparupudi1 · Accepted solution]

Correct syntax should be

table1:

LOAD A+B AS X,Y;

SQL SELECT A,B,Y FROM... WHERE...;

Then the fields in table1 will be X,Y?

[Qrishna]

Just X,Y