Forum Discussion
Merging tables based on condition
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!
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?
2 Replies
Hi Stinkin_linkin ,
Please try.
= Table.TransformColumns(#"Merged Queries",{"Table1", each Table.SelectRows(_,each [Input]=1)})Best Regards,
Gao
Community Support TeamIf 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
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?
