Lookup Function

[#1]

Hi,

Now that the Lookup() function is gone, how do I do an easy lookup?

Unique ID	ColA	ColB	ColC
1	xxx	yyy	zzz
2	rrr	sss	ttt
3	uuu	vvv	www

Say I have id=2 and col='ColC'. How do I get to 'ttt' now without creating millions of mapping tables?

Thanks!

[IAMDV · Accepted solution]

Have you tried using Only() function with Set Expression?

Cheers,

DV

[rogerioqv]

And the function FIRSTSORTEDVALUE?

[#4]

Deepak, I think this is it!