If/Then trouble

[nihou]

Source

PC	CBM
3	CBM
7	NON CBM
8	NON CBM
3	NON CBM
7	NON CBM
8	CBM
3	CBM
7	CBM
8	CBM

Desired Output

PC	CBM
33	CBM
7	NON CBM
8	NON CBM
3	NON CBM
7	NON CBM
33	CBM
33	CBM
33	CBM
33	CBM

I am trying to use the formula tool to change the PC, where CBM = CBM, when CBM= NON CBM, I want it to stay the same

any tips?

[Sebastiaandb · Accepted solution]

@nihou 

Here you go: 

This should work out for you! Just let me know if this is what you're looking for! Greetings Seb

[dbmurray]

Do you have to change the PC field?

Should be able to do this using the formula tool

This will create a new field which does what you need.

You could then use a select to drop and then rename the new field to PC and get your exact output. Alteryx workflow attached.

Workflow attached

good luck

Darragh

Ps. please consider selecting this as the 'solved' answer if it solves your query. 

[dbmurray · Accepted solution]

Here's an alternate flow that does _exactly_ what you're asking and simply replaces PC with 33 if CBM is in the CBM column.