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.
SOLVED

split few rows in separate column

NitishSrivastava
7 - Meteor

Hi All, 

Pls help to look into below query.

 

Is it possible to split few rows or cells from from a column and display it in two columns like below: 

 

Regards

Nitish 

 

Input
 
Customer Name
Sushant Ranjan
Nancy Khanna
John Mick
David Dubis
David Sharma
Albert Nicos
Nia Sharma
Nuria Genebat

 

Output 
  
Customer NameCustomer Name
Sushant RanjanNancy Khanna
David DubisJohn Mick
Albert NicosDavid Sharma
Nuria GenebatNia Sharma
4 REPLIES 4
grazitti_sapna
17 - Castor

Hi @NitishSrivastava , the solution is applicable for this particular dataset.

grazitti_sapna_0-1613641829879.png

 

If this is what you are looking for kindly mark this post as solution.

Thanks.

 

Sapna Gupta
PhilipMannering
16 - Nebula
16 - Nebula

Hi Nitish,

 

A few ways to do this, but the simplest is using the Make Columns Tool. See configuration in screenshot below,

PhilipMannering_0-1613642005702.png

 

Thanks,

Philip

 

NitishSrivastava
7 - Meteor

Thanks a ton @PhilipMannering

 

It is helpful.

 

Regards

Nitish 

NitishSrivastava
7 - Meteor

Thanks .@

 

 

 

 

 

 

Labels