Selecting data from a previous LOAD

[#1]

Hi,

Not sure if I can do this.. but lets say in my script I have:

MyTable:

LOAD Column1,

  Column2,

  Column3

FROM MySpreadsheet.xlsx

(ooxml, embedded labels, table is Sheet1)

But within this LOAD I have elements I wish to load into other parts of my Qlikview report, but rather than having to do another LOAD with a WHERE clause to select only some of the data from the same sheet, can I select from MyTable?

So MyTable:

bla bla bla

Then

MySecondTable:

bla bla bla

FROM MyTable

WHERE bla bla bla

Is this possible and can anyone provide some example syntax? Thanks

[#2]

Well I prefer to qualify everything... is there a way around this? I am going to have multiple tables and many with the same naming conventions... I know I could use 'AS' for each, but I would prefer to not to...

[CELAMBARASAN]

If you are about to remove the Qualify *;

Then you should rename the Fields

or

check it by using No Concatenate before load.

[CELAMBARASAN]

You should rename with AS keyword

Try Qualify * ;

After the MainLoad Table.

[#5]

I got Field not found - <MTD_GDBR.MyDate>

I also tried MainLoad.MyDate but got:

Field not found - <MyDate>

[#6]

Well, that worked.. but why? And this means I can't qualify my main load.... which is annoying.

[CELAMBARASAN]

It is not possible drectly. but you can achieve by something like

Temp:

Load From Excel:

Qualify *;

MainTable:

Load

*

Resident Temp;

SecTable:

Load

*

Resident Temp Where condition;

After all your process based on the Temp Table drop it finally.

Drop table Temp;

All of your table is now loaded with table prefixes.