Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Best way to filter Table based on other table

Hi all!

What is the best way to filter a table based on the values in a different table?

I have 1 holistic sales table with the sales nr and a different table with a sales nr.

I would like to filter the holistic sales table based on the second table.

Would you do that with a LEFT Join and then to filter on matching records?

From a performance standpoint what is here the best approach?

Need Help
  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    4 years ago

    Hi joshua1990 ,

     

    I would place a buffer on the reference table (i.e. the second table), then use Table.SelectRows(RefTableName, (x)=> x[RefColumnName]=[ColumnName]). I find this approach has a better performance compared to NestedJoin.

     

    Regards

    KT

     

1 Reply

  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    Hi joshua1990 ,

     

    I would place a buffer on the reference table (i.e. the second table), then use Table.SelectRows(RefTableName, (x)=> x[RefColumnName]=[ColumnName]). I find this approach has a better performance compared to NestedJoin.

     

    Regards

    KT