I would like to reorganize the attached data (image) into two fields; City and Postcode - what would be the best way to do this?
@Gilld
It didn't re-order for me.
Here's the packaged workflow
@LordNeilLord
Part time Tableau, Part Time Alteryx. Full Time Awesome
Hi @Gilld,
I'd go for something like this logic, if there are no numbers in the field (and I'm not aware of any UK city with numbers in the name) then it's a city else its a postcode. Then applying this logic to a multirow formula you can get something like this:
Example attached
Did the solution work?
Thanks for this @LordNeilLord !! Sorry I can't seem to split the field into 'contains numbers' and 'doesn't contain numbers'?
Thanks for this!! Sorry I can't seem to split the field into 'contains numbers' and 'doesn't contain numbers'?
