cancel
Showing results for 
Search instead for 
Did you mean: 

How do I create logic for below data to get output.

Highlighted
NiCd Battery

Hi,

I need help to create a logic for the below sample data. could someone please help with this?

 

CodeLookupLookup ValuePAXATA OUTPUT
AMERICAN   
B  B
E  E
D  D
KOREAN   
ENENAA
ELELBB
DEDECC
CSCSDD
Labels (1)
1 Reply
Highlighted
DataRobot Employee
DataRobot Employee

Hi @H369199 , 

This could be accomplished by performing a Left-lookup, followed by a computed column expression using

FirstNonBlank(@lookup_value@, @code@)