Copy column value to another column

Question

Hi Everyone,

I am new in alteryx and I am experiencing difficulty in copy the data below:

What I am trying to do is if column Client = "Manila Case Study" then Job Code should be equal to Project Code else no changes will be made

I created the following formula below:

However Upon execution the Job Code value become 0

grazitti_sapna · Accepted Answer

Hi @Rinkashime , is it possible for you to share your workflow so that we can fix the issue in the workflow itself?

or give this a try

if client="Manila Case study" then projectcode else jobcode endif  instead of jobcode=projectcode

Thanks.

vizAlter · Accepted Answer

Hi @Rinkashime — Try this one...

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.