Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have two columns, each containing a List, both created using delimiters on a single cell of text.
eventType | eventBy |
List | List |
Each List contains a string corresponding to the position in the List (e.g. eventType {deleted, added, renamed} and eventBy {1/1/23, 2/12/22, 10/12/22}). There can be many items in lists.
How can I concatenate these into a new List, with the same number of items? e.g. {"deleted 1/1/23", "added 2/12/22", "renamed 10/12/22} ?
The closest I seem to have gotten is this:
List.Combine(List.Transform([eventType], (L1) => List.Transform([eventBy], (L2) => L1 & L2)))
which concatenates but generates new items (I don't understand what the => is doing here)
Solved! Go to Solution.
Hi,
= List.Transform(List.Zip({List1,List2}), each _{0} & " " & Text.From(_{1}))
Stéphane
Thank you, this is perfect!
Hi,
= List.Transform(List.Zip({List1,List2}), each _{0} & " " & Text.From(_{1}))
Stéphane
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.