Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Need to input blank rows after segregating with a certain condition

B_bhatta
7 - Meteor

I am trying to segregate buy and sell transactions in "Sheet 1" tab into Buy transactions first and then incorporate a few blank rows and then a heading as sell transactions post which the sell transactions would be listed. I have tried using a text input tool with blanks but it isn't coming in the desired format. Attaching the input listed in sheet 1. The desired output tab shows the output I need. Can you please help me in tweaking my attached workflow. Thanks a lot!

2 REPLIES 2

Hi @B_bhatta 

 

I tweaked a bit your Text input and Union. Take a look and let me know. Cheers!

 

christine_assaad_0-1604518942917.png

 

B_bhatta
7 - Meteor

Thank you @christine_assaad  it worked out! 😊

Labels
Top Solution Authors