Alteryx Designer Desktop Discussions

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

Copy data from one row to another row based on condition

Lakshmikanth_2021
8 - Asteroid

I have an input file as below,

CollegeAddressDateStudent
College AIndia01-06-09Student1, Student2, Student3

 

As there are multiple student names separated by comma (,) I need to copy the same data of College, Address and Date and Student like below. 

CollegeAddressDateStudent
College AIndia01-06-09Student1
College AIndia01-06-09Student2
College AIndia01-06-09Student3
2 REPLIES 2
sparksun
11 - Bolide

Text to Column tool can do it easily.

sparksun_0-1686281183801.png

 

Yoshiro_Fujimori
15 - Aurora

Hi @Lakshmikanth_2021 ,

You can use Text To Columns tool.

Yoshiro_Fujimori_0-1686281186462.png

Formulat tool is to remove the leading spaces.

 

I hope this helps.

Labels