Rows In Column Split using Alteryx

NitishSrivastava

Hello Team,

Pls help me on below query.

How we can split our country /city separately using Alteryx. Below is the sample of Input and Output data.

Input

Country/City

England

India

NewYork

Lords

Delhi

Mumbai

Output

Country	City
England	Lords
US	NewYork
India	Delhi
India	Mumbai

Developer

Regex

Accepted answers

grazitti_sapna

Hi @NitishSrivastava , I do not think there is any other way to sort this list automatically. One of the way I could think of is to provide a list of world cities along with the country then use join tool and join on the basis of cities. As shown in the screenshot below.

This is the easiest and best way to do so according to me but let's see if anyone else has an interesting solution to solve this.

Thanks.

grazitti_sapna

Hi @NitishSrivastava , I am glad my post is helpful to you. If it really helped can you please mark my post as solution so that it could be useful for other community members looking for something similar.