Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

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
19 - Altair
19 - Altair

@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
19 - Altair
19 - Altair

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

Qiu
19 - Altair
19 - Altair

@Huchida 
How about this one.

0331-Huchida-1.PNG

Huchida
6 - Meteoroid

@Qiu 

Thanks a lot!!

Qiu
19 - Altair
19 - Altair

@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