Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Nested Headers-Complex Transformations

Huchida
6 - Meteoroid

I want to analyze the data file with nested headers as attached.

Please teach me the workflow to make output image from row data.

Best regards

Huchida_0-1617166682908.pngHuchida_1-1617166694228.png

 

6 REPLIES 6
Qiu
20 - Arcturus
20 - Arcturus

@Huchida 

Hope this works for you.

0331-Huchida.PNG

Huchida
6 - Meteoroid

@Qiu 
Thank you for your response.

 

In your workflow, the output is inconsistent with my output image.

In detail,

・In raw data, Team A to C work for only House Segment.

・And, Team D to F work for only Office Segment.

・House Segment and Office Segment is the part of Construction Segment

=>exp: Team A work for House Segment and the cost breakdown is COGS material 453, COGS labor 282 ・・・, SG&A utility 563 and SG&A other 109.

 

I used to analyze with Excel Power Query, and with Power Query I can use transformation ( ≠ Pivot and Unpivot, = change layout into exact opposite). However, with Alteryx I cannot change layout like that......

 

 

 

 

 

Qiu
20 - Arcturus
20 - Arcturus

@Huchida 
Sorry about that.
Let me try to fix that.

Qiu
20 - Arcturus
20 - Arcturus

@Huchida 
How about this one.

0331-Huchida-1.PNG

Huchida
6 - Meteoroid

@Qiu 

Thanks a lot!!

Qiu
20 - Arcturus
20 - Arcturus

@Huchida 
It is really a brutal force approach and certainly requires some modification for your really bussiness application.
thank you for the accept mark😁 

Labels