Hi Community,
Normally I have no problem fixing data in Alteryx, but today I got some data, that I kind quite can't figure out how to solve
The data looks something like this:
Apparently some data has been concatenated, but not all of them,
I´ve tried the Text to Columns tool. but that only takes one column at the time :(
The "logic" is, that the concatenated fields all have the same position on the row, so the final result would be something like this
Feel a bit like I have made a challenge without knowing the answer.
The tricky part is there, that can be potentially many concatenated fields, and many columns in a mix of concatenated data and not (unique)
But the rule is always, that there is the same amount of concatenations on each row.
Right now I am stuck at this, which besides it doesn't work isn't very dynamic either
/V
Solved! Go to Solution.
After I made the post, I did go down that path as well, but not with the greatest success
So brilliant use of the Tile tool, thanks 🙌
/V