Add Left Join

[Anonymous]

Hello All,

I am working on an application which was already developed by someone else. I came across one of the joins condition "Add Left Join", at first I thought it must be "Add Load', but it seems that it is "Add Left Join", I would like to know if it exists or not before going into a discussion with the concerned people. If that particular condition exists can anyone please explain it's working.

Thanks in advance.

[avinashelite]

no , since Add keyword is used with the left join ...the table after the add keyword  will be loaded in the partial reload ...

Try like this

Temp:

LOAD * Inline

[

Product_ID,Name

1,A

2,B

3,C

];

Add left Join

LOAD * inline

[

Product_ID,Amount

1,100

];

when you hit normal reload both the tables will get loaded

ry like this

//add the 4,D to the temp table and now hit partial reload , only the 2 table  will get loaded and the newly added add in the Temp will not be added.

Temp:

LOAD * Inline

[

Product_ID,Name

1,A

2,B

3,C

4,D  

];

Add left Join

LOAD * inline

[

Product_ID,Amount

1,100

2,200

];

[Peter_Cammaert · Accepted solution]

Yes they are equivalent.

ADD, LEFT and JOIN(tablename) are all LOAD statement prefixes. The order in which you specify them is not important. As prefixes generally do, they should be placed before the LOAD keyword.

[Anonymous]

Hi Avinash,

Thanks for the detailed reply.