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