Another lookup funtion quesiton (multiple selection criteria needed)

[#1]

Hello,

Is it possible to use the lookup function to return the descr field where the index is 1 and MenuCode is 246?

I have tried and failed!

t1:
LOAD * INLINE [
index,MenuCode,descr
1,247,'Blah'
1,246,'Active'
];

Regards

Mark

[#2 · Accepted solution]

Hi Rovers ,

I can provide you the syntax of vlookup command , you can use it as per for your needs .

Sytax for vlookup

lookup('requiredcolumnfrmMaster','lookupcolumnfrmfrmMaster',[lookupcolumnfrmdestination],'Mastertablename'')

In your case you can combine "index" and "MenuCode" field & do the lookup on destination table.

something like :

t1:
LOAD * INLINE [
index,MenuCode,descr,index_MenuCode
1,247,'Blah',,'1,247'
1,246,'Active',,'1,246'
];

Cheers

Bhushan N

Regards,

Bhushan N