Transforming data with multiple transpose dimensions.

sebastian123Han

Hey! I have a problem with a dataset that needs to be transformed.

I have attached the data. Basically what I want to do, is having the column headers for (Center, Period ( with values months and year), Type, KPI (basically the column that already exist) and Value).

I have tried a lot of different solution, first assigning record ID transposing and so, but I find it extremely difficult getting to correct structure of the new dataset.

Can anybody help here? The excel linked is how I wish the data to come out:

DataForParsing.yxdb

NewDataLook.xlsx

atcodedog05

Hi @sebastian123Han 

Here is how you can do it. The above branch handles headers and the below branch handles data.

Workflow:

Hope this helps : )

transpose.yxmd