Power Query Nested Table to String

Question

I have an xml that i'm processing and my output is the below image:

Print1

The problem is that i get 2 columns and one has a nested table inside and the other one just the value.

My output need to be something like this:

Print2

Can anybody help?

Is there a way we can reproduce this?

QHarr
– QHarr

2018-04-11 17:46:28 +00:00
Commented Apr 11, 2018 at 17:46 — QHarr
– QHarr, Commented Apr 11, 2018 at 17:46
Please edit the additional information into your question

QHarr
– QHarr

2018-04-11 18:07:51 +00:00
Commented Apr 11, 2018 at 18:07 — QHarr
– QHarr, Commented Apr 11, 2018 at 18:07

Alexis Olson · Accepted Answer · 2018-04-11 18:48:34Z

1

Try adding a new custom column like this:

= Table.AddColumn(PreviousStepNameHere, "FREQ Expanded",
      each if Value.Type([FREQ]) = Value.Type("text") then [FREQ]
           else Table.ToList([FREQ]))

And then expand that new column using this code:

= Table.TransformColumns(#"Added Custom", {"FREQ Expanded",
      each if Value.Type(_) = Value.Type("text") then _
           else Text.Combine(List.Transform(_, Text.From), ","), type text})

If your type for non-tables is something else, then adjust accordingly.

answered Apr 11, 2018 at 18:48

Alexis Olson

40.4k8 gold badges51 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Power Query Nested Table to String

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related