Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
17 - Castor

@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
17 - Castor

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

Qiu
17 - Castor

@Huchida 
How about this one.

0331-Huchida-1.PNG

Huchida
6 - Meteoroid

@Qiu 

Thanks a lot!!

Qiu
17 - Castor

@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