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

US

NewYork

Lords

Delhi

Mumbai

Output
Country	City
England	Lords
US	NewYork
India	Delhi
India	Mumbai

[Qiu]

@NitishSrivastava 

I would really like to see how this get answered.

[grazitti_sapna · Accepted solution]

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.

[Qiu]

@grazitti_sapna 

You are making good suggestion, but I believe the Lords and NewYork is not legal City Names.

And the worldcity.csv looks familar.😁

[grazitti_sapna]

@QiuYes, you are right!  Lords is a cricket stadium in England and New York is a city in United States whereas England is not listed as a Country anywhere therefore I used United Kingdom. The solution above is just a suggestion and the file can be customized as per the requirement.

[NitishSrivastava]

Thanks a lot Sapna Gupta for giving your time on my query and response.

And yes we can sort this using join tool.

Best Regards

Nitish 

[grazitti_sapna · Accepted solution]

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.

Thanks.

[NitishSrivastava]

Hi Qiu,

This table is only to understand logic.

Thanks

Nitish

[NitishSrivastava]

Hi @grazitti_sapna ,

Marked ...!!

R, Nitish 

[grazitti_sapna]

@NitishSrivastava , Thanks.