Data cleaning

[Feras95p]

Dear all,

as you can see in the second column I have made (order_id) with a serial number of the id and each id will have the same serial number as you can see in 8, 9 and 10. I have made this manually but I need to do it with alteryx  with the rest of the rows. One more thing in (shipping address) I want to take the second word after the cooma and write it in the (district name as you can see I made the first 10 manually and I want to make a workflow to do for the others).

Any help in that please?

Thanks in advance for your kind support. 

[Jonathan-Sherman · Accepted solution]

Hi @Feras95p,

I think this is what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Feras95p]

Thanks a lot for your help!