The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

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

Bifurcation between of various transactions type within one excel sheet.

B_bhatta
7 - Meteor

Can you please me modify my "Sheet 1" tab dataset into the "Desired output" tab format. Thanks a lot!

5 REPLIES 5
mbarone
16 - Nebula
16 - Nebula

While we won't do the work for you, I can suggest that you familiarize yourself with the Filter Tool & Union Tool.

B_bhatta
7 - Meteor

I have used the filter tool and but when i bring together both nodes, I am not being able to get a space between the segregation. Hence, need some guidance.

 

BBhatta26_0-1604424292539.png

 

mbarone
16 - Nebula
16 - Nebula

You can use a Text Input tool to create however many "blank" rows you need and union that in as well.

B_bhatta
7 - Meteor

Thank you so much. I will follow that approach ðŸ˜Š

mbarone
16 - Nebula
16 - Nebula

Welcome!

Labels
Top Solution Authors