Which step should you use in the query?

You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?
A. =Table.ExpandListColum(Table.TransformColunins(Source, {{“classes”.
Splitter.SplitTextByDelimiter(”,”, QuoteStyle.None), let itemType – (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), “classes”)
B. = Table.Unpivot(Source, {“classes”}, “Attribute”, “Value”)
C. = Table.SplitColumn(Source, “classes”. Splitter.SplitTextByDelimiterf”,”, QuoteStyle.None),
{“classes.1”})
D. = Table.SplitColumn(Source, “classes”. Splitter.SplitTextByPositions({10}), {“classes.1”})

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.