I have a table (A) with a column that contain IDs. I have another table (B) with a list of IDs.
I'd like to filter table A, to include all the values that match those in table B.
I've made a derived table from table A, and then used match to try and filter by the ID column in table But I think I might be approaching this incorrectly, as when I use an aggregate function to get a sum, it seems to still be the same sum as the full dataset. Am I perhaps approaching this wrong?
Hello Cwokral, welcome in this community!
if I understand correctly, you have a table similar to the following one:
And you have another table that contains the IDs to keep:
In that case, use the Keep/remove matching action:
The result will be:
I hope that this could help you!
1 Like
Thank-you for your welcome, and help. This solves it.