Load relevant rows from respective table by referencing another existing table

[mondaywoker]

I have a table (ARBC) that needs to filter out a series of values which I need to get from another table (Sheet 2).

ARBC comes with columns A, B, C & D.

Sheet 2 comes with only one column call E.

I need to filter out values of column D in ARBC table base on the values from column E at Sheet 2.

And after filtering, I will need to use the final result of ARBC to join with another table (Sheet 3).

How can I do that?

[rubenmarin]

Hi, you can just load ARBC table.

Do an inner join to reduce to the values of sheet2.

And join with the 3rd table as any other join.

LOAD A,B,C,D From... ; // Sheet1
Inner Join LOAD E as D From... ; // Sheet2
Inner/Left/Right/Outer) Join LOAD ...  From... ; //Sheet3