Update Column with condition

How to update Column C with EXP and REV word

1. if Column A first two digits are 15 then Column B # then replace Column C with "REV".

2. if Column A first two digits are 17 then Column B # then replace Column C with "EXP".

Column A	Column B	Column
154589	#	n/a
17456	#	n/a
154589	#	n/a

Developer

In Database

In-Database

Accepted answers

@ksarker you just need to change @FinnCharlton 's logic slightly:

Update Column with condition.yxmd

All comments

@ksarker One way of doing this

Formula_140313.yxmd

Hi @ksarker , here's a way to do this with a Formula tool:

Hope this helps!

Update Column with condition.yxmd

thanks both of them are helpful. but if i have more information such as below with two more rows then how to implement these formulas without having any change into last two rows (EXP, REV) because now it's changing all other items into NULL. I want to keep last two rows as it is no changes for last two rows.

Column A	Column B	Column
154589	#	n/a
17456	#	n/a
154589	#	n/a
6504	ABC	EXP
4809	XYZ	REV

@ksarker you just need to change @FinnCharlton 's logic slightly:

Update Column with condition.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703