Forum Discussion
dstanisljevic
Helper I
Helper IExtract List Data with Nulls
I'm trying to extract data from a list: I'm using the built-in tools via Desktop, however, running into some issues. When I use the extract values from list tool and add my delimiter fo...
You may want to use one of the core Combiner functions instead of the "user friendly" Text.Combine.
If I didn't make mistakes, the following should work (but I can't test it):
= Table.TransformColumns(#"Expanded Value.rows", {"Value.rows", each Combiner.CombineTextByDelimiter("$")(List.Transform(_, Text.From)), type text})
MarcelBeug
Community Champion
Community ChampionYou may want to use one of the core Combiner functions instead of the "user friendly" Text.Combine.
If I didn't make mistakes, the following should work (but I can't test it):
= Table.TransformColumns(#"Expanded Value.rows", {"Value.rows", each Combiner.CombineTextByDelimiter("$")(List.Transform(_, Text.From)), type text})
dstanisljevicHelper I
Helper IThat's working. Awesome, thank you!