Transpose Options

[Karthick461]

Hi ,

 I have a Dataset like below

How to change this data set (DS has null values too) like below ( basically transpose of month and values based on brand )

[FrederikE]

Hey @Karthick461,

I am not sure that this transformation is what you really want to do. 

"( basically transpose of month and values based on brand )"  - That's not what your result dataset is, you assign categories to each other that have no previous relation.

For example Row 1, Column 4 (Column: Panel, Brand: Trust, Month: Dec-17) - this is no value in your orignial dataset but a random assignement.

[binu_acs]

@Karthick461 One way of doing this

[Karthick461]

Hi @binu_acs 

 Thanks for your response.. This is what actually I want.. except one more addition..

I just need one more column which shows school and college.. because in Brand column , we are getting 2 trust , 2 panel and 2 viva.. but need to know which one is for school and which is for college.. that info is also required.. 

Any way to achieve that

[binu_acs]

@Karthick461 You need to input an Excel file to achieve this. Attaching the updated workflow

[Karthick461]

Sorry @binu_acs .. Workflow you sent is created in latest version it seems and its not opening for me.. Is it possible to send this as YXMD and that source file.. I can try to run with that flow

[binu_acs]

@Karthick461 sure

[binu_acs]

@Karthick461 When you try to open the .zip file what was the error message you were getting? follow the below post to degrade your workflow

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...