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

[H369199]

Hi,

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

Code	Lookup	Lookup Value	PAXATA OUTPUT
AMERICAN
B			B
E			E
D			D
KOREAN
EN	EN	A	A
EL	EL	B	B
DE	DE	C	C
CS	CS	D	D

[shyam · Accepted solution]

Hi @H369199 , 

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

FirstNonBlank(@lookup_value@, @code@)