Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

convert distinct row values and into a new column with a seperation

Highlighted
6 - Meteoroid

I have a need to take the distinct URL values and convert them into a new column like this:

 

input file:

input.JPG

 

I need to take the different values of " google.com/URL*" and paste into a new column so I can further proess my data:

 

Output:

output.JPG

 

Since the values are seperated by "URL by Countries", what are the tools that I could use to achieve my goal? Thank you in advance.

 

Attached is excel file.

 

 

Highlighted
12 - Quasar

@wendy_lu

 

try the attached one

what i did was,

1. removed all extra null rows

2.Used Multi Row formula to update the URL field

 

thanks

Saravanan

Highlighted
6 - Meteoroid

works great, Saravanan! 

Labels