Load relevant rows from respective table by referencing another existing table

mondaywoker — Mon, 26 Jan 2026 21:26:37 GMT

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?

Re: Load relevant rows from respective table by referencing another existing table

rubenmarin — Fri, 28 Oct 2022 12:54:50 GMT

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