You have a query that returns the data shown in the following exhibit.
You need to configure the query to display the data shown in the following exhibit.
Which step should you use in the query?
A. = Table.SplitColumn(Source, “classes”,
Splitter.SplitTextByDelimiter(“,”, QuoteStyle.None),
{“classes.1”})
B. = Table.Unpivot(Source, {“classes”}, “Attribute”, “Value”)
C. = Table.SplitColumn(Source, “classes”,
Splitter.SplitTextByPositions({10}), {“classes.1”})
D. = Table.ExpandListColumn(Table.TransformColumns(Source,
{{“classes”, Splitter.SplitTextByDelimiter(“,”,
QuoteStyle.None), let itemType = (type nullable text) meta
[Serialized.Text = true] in type {itemType}}}), “classes”)