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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
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

Highlighted
Meteoroid

works great, Saravanan! 

Labels