In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Swapping specific data

AJ
5 - Atom

Hello, 

Attached is an Excel file with sample of the data I want help with. I have 2 columns, old and new Order numbers. If the Old OrderNo starts with 004**** do nothing, but if it's starts with 002****** then swap the Old Order No with the New OrderNo field. 

So for Ex: Old OrderNo from the Excel 0040000637 will not be swapped, however Old OrderNo 0021814608 will be swapped with 0040003320 New OrderNo. Also If the Old OrderNo starts with 002**** and there is No New OrderNo then keep the Old OrderNo. as in the last record in the Excel file


Thoughts?

 

Thanks.

1 REPLY 1
binuacs
21 - Polaris

@AJ use the StartsWith function for this use case

 

binuacs_0-1680802994067.png

 

Labels
Top Solution Authors