New Column based on a Condition with output reference from Another Column

HI All ,

I have below Table having Suppliers in 3 different Columns & Type in the last as shown below :

Supplier 1	Supplier 2	Supplier 3	Final Type
XXXX	YYYY	XXXX	GRIP 4
AAAA	BBB	YYYY	M12 Pins
BBBB	CCCC	ZZZZ	1/4 Pin

I need to Add the Final Supplier Column based on the Final Type . If , Type Contains "GRIP" , reflect the Supplier from Supplier 1 Field , if Type Contains "M12" reflect the Supplier from Supplier 2 & if it Contains "1/4" then Supplier 3.

Desired Output below :

Supplier 1	Supplier 2	Supplier 3	Final Type	Final Supplier
XXXX	YYYY	XXXX	GRIP 4	XXXX
AAAA	BBB	YYYY	M12 Pins	BBB
BBBB	CCCC	ZZZZ	1/4 Pin	ZZZZ

I tried using the Formula tool , however it doesn't refer the value from a Column . May be I am using an incorrect Tool.

Datasets

Common Use Cases

Fuzzy Match

Accepted answers

Hi @DVikas , is this what you are trying to achieve?

Formula - if Contains([Final Type],"GRIP") then [Supplier 1] elseif Contains([Final Type],"M12") then [Supplier 2]
elseif Contains([Final Type],"1/4") then [Supplier 3] else null() endif

formula-GS.yxmd

All comments

Hi @DVikas , is this what you are trying to achieve?

Formula - if Contains([Final Type],"GRIP") then [Supplier 1] elseif Contains([Final Type],"M12") then [Supplier 2]
elseif Contains([Final Type],"1/4") then [Supplier 3] else null() endif

formula-GS.yxmd

Thanks @grazitti_Sapna

I tried doing the same thing , however didn't work. But I don't know how , it works now. Thanks for the help.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703