Comparing State Column with Concatenated Country Data

[himanshu_v_17]

In the dataset, I have three columns: State, Country, and Concatenated Countries. Unfortunately, some values in the "State" column have been misplaced with those of the "Country" column. The "Concatenated Countries" column contains concatenated country names for each row. The objective of this data analysis is to compare the values in the "State" column with the corresponding entries in the "Concatenated Countries" column to identify any discrepancies and then replace them in the country.

[ShankerV]

Hi @himanshu_v_17 

By the way I understood your requirement it is an easy task with the help of alteryx.

However I would appreciate if you are able to share few sample data so that it would be helpful to share the accurate flow which will work for your data set.

Many thanks

Shanker V

[himanshu_v_17]

Hi @ShankerV 

Thank You for the reply 

Hereby I am attaching a sample workbook of the data.

[ShankerV]

Hi @himanshu_v_17 

In the excel sheet attached, I see City and State column.

Country column in empty.

What is the expected output you are looking for.

Thanks in advance.

Many thanks

Shanker V

[himanshu_v_17]

Hi @ShankerV 

Thanks for the reply 

So in the state column, there have been entries that should have been in the country column so by comparing the values to the concatenated column if there are values present they should be swapped to the country column, or if there is another way you can suggest it will be good because we cannot just transfer the data in state column to go to the country because in some places state is correct I hope it helps .