I am new to Alteryx, and I want to split my data into new columns Country, EmpID, PlantID, and PayPeriod (W or Mo). An example of a data point I have is SWE468-4Mo, and I want to split it up like this:
Country- SWE
EmpID- 468
PlantID- 4
PayPeriod- Mo
How would one go about this?
Hi @mark_9876 ,
Here you go!
Split the column first, then use the Cross Tab tool to create a column & row. Solution attached.
Regards,
Tom
how structured is this field? Is it consistent in field lengths?