topic Re: Preceding Load before Join statement in QlikView

Preceding Load before Join statement

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to understand that can we use preceding load before Join statement.

i have 2 tables A and B after applying join two tables can i use Preceding load in table A.

can any one suggest

Thanks

Rajesh

Re: Preceding Load before Join statement

rubenmarin — Thu, 17 Aug 2017 09:55:02 GMT

Hi rajesh, the preceding load in table A can be done before joining them. If you need fields from both tables to create a calculated field you can do a resident load of the joined table:

Rename Table JoinedTableName to JoinedTableNameAux;

JoinedTableName:

LOAD *, // all fields

NewFields

Resident JoinedTableNameAux;

DROP Table JoinedTableNameAux;

Re: Preceding Load before Join statement

Rajesh — Thu, 17 Aug 2017 10:02:04 GMT

Thank you Ruben for made me understand.

Re: Preceding Load before Join statement

Anil_Babu_Samineni — Thu, 17 Aug 2017 10:05:02 GMT

If you found understand / helpful close this thread

Re: Preceding Load before Join statement

carlcimino — Tue, 11 Dec 2018 19:39:44 GMT

My question is why should you have to do it? Since a preceding load runs from bottom to top why wouldn't the script recognize the join and allow the use of the result of that join? Seems like a waste to have to reload an entire resident table. Is there an explanation anywhere?