Alteryx Designer Desktop Discussions

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

Transpose tool

aparna0208
8 - Asteroid

Hi,

 

I tried using data cleansing and transpose tool but not getting what I expected. Not sure how to get rid or blanks/nulls and have the date on top as indicated in second example. Need some help. Thank you in advance!

 

Output

 

DateFailsCount
11/6/2020  
 SF CRD not populated880
 Discovery Data CRD not populated240
 SEC# not populated22919
 SV CRD not populated2

 

 

Desired output

 

Fails11/6/2020
SF CRD not populated880
Discovery Data CRD not populated240
SEC# not populated22919
SV CRD not populated2
5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @aparna0208 

 

Can we see your input data.

echuong1
Alteryx Alumni (Retired)

You can use the cross-tab to achieve this. First you'd want to "drag down" the date so it applies to every row. This can be done with the multi-row formula.

 

I added in a dynamic rename to clean up the field name. Special characters are automatically changed to "_" with the cross-tab.

 

echuong1_0-1604679671466.png

 

messi007
15 - Aurora
15 - Aurora

Dear @aparna0208,

 

Suppose your input look like :

 

messi007_0-1604679961694.png

 

I have done Summarize in order to count then I have done the cross tab

 

 

messi007_1-1604680021832.png

 

messi007_2-1604680057194.png

 

Attached the workflow hope that helps

 

Regards,

 

aparna0208
8 - Asteroid

@messi007 thanks for the quick response:) My input is bit different so had to add in tools as per other solutions

aparna0208
8 - Asteroid

@echuong1 thanks for the quick response:) It worked as expected. Thank you for your inputs:)

One quick question about adding one more feature. Now the next time when I run the workflow, I want only the date column appended to the right of the existing column. Something like below

 

Fails11/06/202011/6/2020
Discovery Data CRD not populated240240
SEC# not populated2291922919
SF CRD not populated880880
SV CRD not populated22

 

But when I append the output to same file and run the workflow it doesn't seem to work. It gets appended at the bottom as seen below

 

Fails11/06/2020
Discovery Data CRD not populated240
SEC# not populated22919
SF CRD not populated880
SV CRD not populated2
 240
 22919
 880
 2

 

Is there a way to append the output during my next run as indicated in first example?

 

Thanks!

Labels
Top Solution Authors