Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hello! I am trying to move data from one field to another. If the Address field contains "PO Box" at all, then the content of that field needs to be transferred to the "PO BOX" field. I tried to do an IFTHEN formula, but I'm not sure how to get rid of the data from the Address field after it was moved to the PO Box field.
So for example, the address for Exit 13 Magazine is a PO BOX. That needs to be moved to the "PO Box" field.
Thank you in advance!
Solved! Go to Solution.
Hey @shingrac ,
The reason you might be having difficulty is that you can't do this in one formula. You need two calculations to update both fields. See the example attached,
