Forum Discussion

Post Patron

7 years ago

Solved

PowerQuery Filter by List

Hello,

I need, in PowerQuery, create a step to filter a by field ( JOB) Table (CGJOBS (2) using a list already created (realocList).

Thanks

Anonymous
7 years ago
Fcoatis,
You first need to convert your list to table, then use Merge Queries transformation, and select Inner Join as the join type on the two columns

4 Replies

Anonymous
Not applicable
7 years ago
Fcoatis,
You first need to convert your list to table, then use Merge Queries transformation, and select Inner Join as the join type on the two columns
- Fcoatis
  Post Patron
  7 years ago
  Why didn´t I think that? Sometimes we are so determined to a specific type of solution we became blind.
  
  Thanks
  - Anonymous
    Not applicable
    7 years ago
    Fcoatis,
    Sometimes simple solution is efffective ;)
- Anonymous
  Not applicable
  3 years ago
  yes and no... that's not a filter by at query time but a merge. If we want to only keep 10 items out of millions of rows this method would require to first download the 10M rows to then only merge 10.
  
  Filter by list would imply using Table.SelectRows and be able to refer a list of values.

Related content