Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How can I merge the example below into one single row with the third column being the merged, contatenated value?
Thanks!
Solved! Go to Solution.
Hi, @bencruz7
Table.Group(
your_table,
{"Account ID", "Health Plan: Record Type"},
{{"Payer: Name", each Text.Combine([#"Payer: Name"], ", ")}}
)
Hi, @bencruz7
Table.Group(
your_table,
{"Account ID", "Health Plan: Record Type"},
{{"Payer: Name", each Text.Combine([#"Payer: Name"], ", ")}}
)
This worked! Thank you so much!