Preceding Load before Join statement

[Rajesh]

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

[rubenmarin1 · Accepted solution]

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;

[Rajesh]

Thank you Ruben for made me understand.

[Anil_Babu_Samineni]

If you found understand / helpful close this thread

[carlcimino]

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?