Forum Discussion
Solved
Extract 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})
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})
Thanks for this little 'adjustment' save me from a headache