Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

LOAD & SELECT

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!

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: LOAD & SELECT

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?

2 Replies
sasiparupudi1
Honored Contributor III

Re: LOAD & SELECT

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?

krishna_2644
Valued Contributor III

Re: LOAD & SELECT

Just X,Y

Community Browser