We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Cross tab/transpose tool

gtadlimbekar
8 - Asteroid

I have a table like this. 

Screenshot 2023-11-24 1121541.png

I want the above table in following format.

Screenshot 2023-11-24 1117061.png

9 REPLIES 9
Qiu
20 - Arcturus
20 - Arcturus

@gtadlimbekar 
Your data looks very familar to me 😁

1124-gtadlimbekar.PNG

flying008
13 - Pulsar

Hi, @gtadlimbekar 

 

FYI.

 

录制_2023_11_24_14_28_36_771.gif

 

The above flow has good compatibility with more situation like @gawa .

 

Input     
.OperatingDesign   
Pressurekg/cm2 gkg/cm2 g   
 0.13.5/F.V   
TemperatureCC   
 4070   
Flowm3/hm3/h   
 100110   
      
Output     
Operating Temperature (C)Operating Pressure (kg/cm2 g)Operating Flow (m3/h)Design Temperature (C)Design Pressure (kg/cm2 g)Design Flow (m3/h)
400.1100703.5/F.V110

 

gawa
15 - Aurora

@gtadlimbekar 

Please try the attached workflow. I imagine you are having more parameter not only pressure and temperature. My WF can cater for those scenario. Please check it out.

 

image.png

gtadlimbekar
8 - Asteroid

55.png 

 

The multi-row formula is not working. I forgot to mention there is a blank row in between in the input data. 

gtadlimbekar
8 - Asteroid

This solution is somehow working. I forgot to mention there is a blank row present. Can you please let me know the solution for this.55.png

gtadlimbekar
8 - Asteroid

I forgot to mention there is a blank row present. Can you please let me know the solution for this.

55.png

 

gawa
15 - Aurora

@gtadlimbekar Right after Input tool, put Data Cleansing tool, and remove null rows.

gtadlimbekar
8 - Asteroid

66.png

If I apply data cleansing tool, the records change like above.

gawa
15 - Aurora

@gtadlimbekar It should be because of AMP engine. Turn off AMP engine.

BTW, with my WH shared int the above post, it works well even having null rows. Please check it first.

Labels