right join is not working in data loader

[Ethel]

Hello,

could you please help me to figure out what I'm doing wrong?

F1:

Load 

AccountDescriptionType

,TransactionLineItem

, TransactionType

Resident T1;

right join

Load 

     AccountDescriptionType

     ,FY2013

   ,TransactionLineItem

  , TransactionType

Resident T2;

drop table T1;

drop table T2;

T1 table has 100 rows, T2 has 3 rows. Why my final F1 table has only 3 rows? It should have 100 rows.

Thank you very much in advance! 

[PrashantSangle · Accepted solution]

T1 table has 100 rows, T2 has 3 rows. Why my final F1 table has only 3 rows? It should have 100 rows.

Thank you very much in advance! 

> Because you are doing right join.

If you want all 100 records then do Left join.

Regards,

Prashant Sangle

[Ahidhar · Accepted solution]

that is how right join works it gives preference to the table loaded after join in this case the table taken from T2.

so of the 100 rows in First table only the 3 rows that match with Second table will be considered

Below link explains the difference between different joins 

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefix...

[Ethel]

Thank you very much!

[Ethel]

Thank you very much!