Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to add a blank row as desired

Polite123
8 - Asteroid

Hi Team,

 

Need help to add few blank rows in data as shown below:

 

Input data:

 

ABCDE
F1243
G5678
H9101112
I13141516
J171819

 

Output data:

 

ABCDE
     
F1243
G5678
H9101112
     
I13141516
     
J171819

 

Thanks in advance:)

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Polite123 

 

Is there a logic on how the blank rows are added ?

Polite123
8 - Asteroid

No @atcodedog05.I want to add them whenever required.

atcodedog05
22 - Nova
22 - Nova

Hi @Polite123 

 

Here is a workflow for the task.

 

Output:

atcodedog05_1-1602496697556.png

Workflow:

 

 

atcodedog05_0-1602496669633.png

 

You can mention row before which you want blank.

 

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

Polite123
8 - Asteroid

Magical!!!!Thanks a ton:)

 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Polite123 

 

Cheers and Happy Analyzing 😀

Labels
Top Solution Authors