Rename the Country names

Question

hi all,

Below i have provided 2 Sample Data. One is the input and the Other is the required output.

The Country names were the headers At first So when I have read it Alteryx it has been renamed as 2, 3 etc as in Alteryx two fields cannot have the same Names. Those needs to be replaced by the original names as it is. Can someone help me out with this ?

Change City names.yxmd

DataNath · Accepted Answer

Hey @DataPirate26, how does this look? It just replaces all numbers/underscores with nothing. As there's no legitimate case for these being in the name this ought to be fine I think?

DataPirate26 · Accepted Answer

@binu_acs Worked perfectly fine with the solution. Thanx for the quick help