Copy column value to another column

[Rinkashime]

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 solution]

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 solution]

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.

[Rinkashime]

Thanks for all your support both answer are correct! 

[vizAlter]

@Rinkashime — Thank you!