Merging tables based on condition

[Stinkin_linkin]

Hi everyone,

I have an input table with a 0 or 1 for each category, as follows:

Input | Category

1 | Case1

1 | Case2

0 | Case3

0 | Case4

1 | Case5

There are separate tables associated with each of the 5 categories above. If the category has a 1 in the first column, then I want to merge it's table with the others. If there's a zero in front of the column, then I don't want to merge it's table with the others. If there's only zeros, then I don't want to merge any of the tables.

Any advice on this? I'm having trouble referencing a table that is outside of my "Merge Table" query

Thanks!

[v-cgao-msft]

Hi @Stinkin_linkin ,

Please try.

= Table.TransformColumns(#"Merged Queries",{"Table1", each Table.SelectRows(_,each [Input]=1)})

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Stinkin_linkin · Accepted solution]

I couldn't get this method to work, but I did find another solution. First I filter out the zeros from my input table, then I converted my input table into a list, and then did a "filter by list" function in my merge query. Note: my merge query loads all the tables by default, and then filters out the tables that weren't selected by the user.

The code that filters by list looks like this:

= Table.SelectRows(#"Removed Columns", each (List.Contains(#"User selection",[Group]) =true ))

Note: Some of the labels might be confusing without seeing the whole code

Here's a youtube link to video that helped! Hopefully it's okay to post this here?

Power Query - Filtering By a List - YouTube