Union Fields with Matching Numeric IDs

[Navyasree123]

Hello All,

I have a dataset where column names contain numeric IDs but have different text formats due to language variation . for example:

4 salary monthly

4 salario - Miensalistas

I want to union these columns based on the numeric ID while keeping the original name format (e.g.,"4 salary Monthly should reain the same,but "4 salario - Miensalistas" should merge into it.)

However,I'm unsure how to dynamically match columns with similar numeric IDs while keeping the correct name format.

what's the best way to handle this in alteryx,any suggestions would be greatly appreciated!

[OTrieger]

@Navyasree123 

You can create a new field and with RegEx get the numbers from the name. Then you can use that new field as your matching criteria.

[Navyasree123]

@OTriegercan you please share a sample workflow that demonstrates how to achieve this? It would be very helpful!

[OTrieger]

@Navyasree123 

Unfortunately I cannot, however you can do it with a Formula tool or with RegEx parse tool.

[binuacs · Accepted solution]

@Navyasree123, what about the column names that do not start with numbers? Do you also want them to be union, or should only the fields starting with numbers be in the union? Also, are these fields in the same order, or can the field order change in each file?