Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Crosstab is not doing it

AmAm
7 - Meteor

Hi all,

 

So I have a file that list entities name and expenses below in one column as follow: 

AmAm_2-1674589442750.png

 

I want it to be broken down in rows as follow: 

AmAm_3-1674589459011.png

 

I thought a crosstab would do it but it only take the values of the first line or last and concatenate won't work because there are number.

 

I would truly appreciate any help!

 

thanks

3 REPLIES 3
ShankerV
17 - Castor

Hi @AmAm 

 

To achieve the result, you need to filter the filename separately.

Then use the cross tab.

 

Then add Record ID for both streams.

Then join based on the record ID to get the output.

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @AmAm 

 

Please let me know if you need a workflow to be build for the same.

If yes, please share the input in copy paste format, where it can be used for Alteryx input.

 

Thanks.

Felipe_Ribeir0
16 - Nebula

Hi @AmAm 

 

One way of doing this

 

Felipe_Ribeir0_0-1674590300090.png

 

Labels