Unable to pivot data and rename the header

Hi Alterxy Gurus

This is the first time I am posting a question here so apology in advance if I am making any mistake and missed any community rules

Requirement :

I am having two Data set which I am using to get the desired header

First Dataset - Actual Data

Second Dataset- Mapping Table

Alteryx Mapping.png

My first Dataset is having incorrect Hierarchy heading which I need to modify based on my mapping Table but I couldnt able to get the expected output. Can someone please help me with your expertise.

Attaching the sample data for your reference.

Note : (Office Environment )I am using the Alteryx 2018.3

(Personal PC)I am using the Alteryx 2019.3

FYI.. I was able to get my desired output but the workflow is not effective as per my understanding. In my real time scenario, I have roughly around 70 columns and data-set has 40 million rows of data which is taking quite a long time to execute the workflow.

Alteryx Workflow.PNG

Thanks in Advance,

Rajeev

Alteryx Challenge.xlsx

Alteryx Pivot Workflow.yxmd

Transformation

Accepted answers

MichalM

@rajvivan11

This is how I would approach it. I have

Used another input which I use as a template defining the desired order of columns
Changed the Lookup table slightly so I can get both ID and Description into the same column

Workflow attached. Please let me know if anything's unclear.

fix-column-names.yxmd

All comments

MichalM

@rajvivan11

This is how I would approach it. I have

Used another input which I use as a template defining the desired order of columns
Changed the Lookup table slightly so I can get both ID and Description into the same column

Workflow attached. Please let me know if anything's unclear.

fix-column-names.yxmd

rajvivan11

This is really a Clever way to solve this issue .Thanks for sharing your approach.

Will mark you answer correct as soon as I test with my original data

Really loved the below workflow which you used ...Never thought about this and I realized now this approach will solve my other problems as well

I am looking for some more approach ..not only from the point of solving but also wanted to learn new approach techniques

Note : Just FYI..Template is not required actually because you already achieved the output when you transposed it .Select tool will do the rest of the magic

Thanks again.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703