CODEWITHSUNDEEP
azure-data-factory
user2181700
user2181700

Reputation: 177

Pivot data in mapping dataflows

I want to pivot the values into description using mapping dataflows My example So the value column plots to each new description value column.

it should look like this enter image description here

I understand that the groupings will be on the IDName, ID and DateTime columns and I have removed the columns I don't need.

I'd like to know what goes where in the pivot values enter image description here

Thanks

Upvotes: 0

Views: 516

Answers (1)

Abhishek Khandave
Abhishek Khandave

Reputation: 3230

Step1: Create dataflow

enter image description here

Step2: Add original dataset to source

enter image description here

Step3: In Pivot Settings use groupby on ID, IDName, DateTime columns

enter image description here

You will get data preview as expected

enter image description here

Step4: Then Configure Sink with output csv and Store data to target file.

enter image description here

Upvotes: 2

Related Questions