Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. 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
18 - Pollux
18 - Pollux

@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
18 - Pollux
18 - Pollux

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

Qiu
18 - Pollux
18 - Pollux

@Huchida 
How about this one.

0331-Huchida-1.PNG

Huchida
6 - Meteoroid

@Qiu 

Thanks a lot!!

Qiu
18 - Pollux
18 - Pollux

@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