Forum Discussion
Power Query TextJoin
Maviso69 You need to go to advanced editor and then use the GroupedRows step/code, I have uploaded the file here https://drive.google.com/file/d/1M6ULVsU3m_IJc08CupGCwbJXCcVyGPDe/view?usp=share_link to give you an idea.
Community ChampionMaviso69 Create a new blank query in Power Query UI then go to Advanced Editor and paste this code:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXIsKMhJVYrViVZyAvJ8E/PS88E8ZxQeSKVTYh4Q4lAakJpYBFfpnJFaVFQJVxmeWJJalJuak5+HpjwWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Code = _t, Category = _t]),
ChangedType =
Table.TransformColumnTypes (
Source,
{
{ "Code", type text },
{ "Category", type text }
}
),
GroupedRows =
Table.Group (
ChangedType,
{"Code"},
{
{
"Result",
each
Text.Combine (
List.Distinct ( _[Category] ),
", "
),
type text
}
}
)
in
GroupedRows
Apologies for my naivity but trying this out "as is" prom
I'm guessing this part needs to be edited by me according to my system? My "source" is "Table1".....
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXIsKMhJVYrViVZyAvJ8E/PS88E8ZxQeSKVTYh4Q4lAakJpYBFfpnJFaVFQJVxmeWJJalJuak5+HpjwWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Code = _t, Category = _t]),
ChangedType =
Table.TransformColumnTypes (
Source,
{
{ "Code", type text },
{ "Category", type text }
}
),result Error message - "Eof expected"
Further advice would be appreciated - Malcoln
- AntrikshSharma
Maviso69 You need to go to advanced editor and then use the GroupedRows step/code, I have uploaded the file here https://drive.google.com/file/d/1M6ULVsU3m_IJc08CupGCwbJXCcVyGPDe/view?usp=share_link to give you an idea.
Many thanks - much appreciated.
