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?
Solved! Go to Solution.
Here you go:
This should work out for you! Just let me know if this is what you're looking for! Greetings Seb
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.