community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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

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.

 

 

@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

Meteoroid

works great, Saravanan! 

Labels