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.
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
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.