Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Any insights on how to address power bi power query matter outlined in this stackoverflow post?
Note that i had to use stackoverflow because repeated attempts to post here kept messing with the text and code box formatting or erroring out complaining about html being embedded in text.
Solved! Go to Solution.
Hi @rob_mysbxsec ,
Is this what you're looking for?
let
Source = Table.NestedJoin(#"mysqldb support_request", {"id"}, #"mysqldb support_request_tag"[[#"support_request_id"], [#"tag_name"]], {"support_request_id"}, "tag_name_csv", JoinKind.LeftOuter),
#"Transformed tags" = Table.TransformColumns(Source, {{"tag_name_csv", each Text.Combine(_[#"tag_name"], ", "), type text}})
in
#"Transformed tags"
Hi @rob_mysbxsec ,
Is this what you're looking for?
let
Source = Table.NestedJoin(#"mysqldb support_request", {"id"}, #"mysqldb support_request_tag"[[#"support_request_id"], [#"tag_name"]], {"support_request_id"}, "tag_name_csv", JoinKind.LeftOuter),
#"Transformed tags" = Table.TransformColumns(Source, {{"tag_name_csv", each Text.Combine(_[#"tag_name"], ", "), type text}})
in
#"Transformed tags"
@Smauro that worked. Thank you very much. Leaves me wondering what scenario Table.AggregateTableColumn( . . . ) function is for when Table.TransformColumns( . . . ) covers this case.
Without seeing your source data and an example of your expected result it's difficult to envusion what you are trying to do.
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Can you supply the data tables/queries/PBIX file you are trying to merge and an example of the expected result.
But the general approach to joining tables in PBI/PQ is, in the Query Editor, Home Tab, click on Merge Queries -> Merge Queries As New then select the left and right tables, the type of join and the matching/joining column
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Thanks for response. I'm not having any issues setting up left join merge query to new table output. What i'm looking for is way to use #"Aggregate . . . " in lieu of #"Grouped Rows . . ." on column in right side of join to produce single row per left side where there is multiple right side matches and combining a specific column in the right side matches into a comma seperated value using Text.Combine(List.???, ", ") function. This is detailed in the stackoverflow post referenced in the question overview.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |