Lookup Data

bsanthoshpk

Hi All,

Hope you are doing good, I need help below scenario.

Input:

Table 1:

L1	L2	L3	L4
101	522	87	77
102		98	55
	724	89
103	23	899

Table 2:

Code	Desc
101	a
102	c
103	d
522	i
724	q
23	w
87	e
98	r
89	t
899	y
77	o
55	j

Expected Output:

L1 Desc L2 Desc L3 Desc L4 Desc 101 a 522 i 87 e 77 o 102 c     98 r 55 j     724 q 89 t     103 d 23 w 899 y

Thanks in advance.

mgaronson

May not be the most efficient solution. It does work. Note: cannot have multiple columns with same column name.

Lookup Data 2024-03-19.yxmd