Originally posted by: yeswtx

Hi Guys,

coming up with a case where we need to perform multiple lookup on same input objects for different qualifiers.

Input 

LOC|161|yyyy|zzzz|bbbb

LOC|172|qqqq|rrrr|cccc
LOC|165|bbbb|cccc|aaaa

Requirement:-

I need to first check qualifier 165, if not available 161, if not available 172,

but we also have a case where all 3 data can come in the file in any order but we still need to check 165 qualifier 1st.

Thanks for some urgent suggestions,

Rgds,

Originally posted by: paul.brett

Please review the enclosed example.

For input data:

LOC|161|yyyy|zzzz|bbbb
LOC|172|qqqq|rrrr|cccc
LOC|165|bbbb|cccc|aaaa

...the result is:  'bbbb'

For input data:

LOC|161|yyyy|zzzz|bbbb
LOC|172|qqqq|rrrr|cccc
LOC|164|bbbb|cccc|aaaa

...the result is:  'qqqq'

The trick is to drop to a functional map, taking everything required (the whole input) to do a second LOOKUP() function.

Thank-you.

Paul

Follow me on Twitter

Attachment(s)

Lookups.zip   2 KB 1 version

Originally posted by: yeswtx

Thanks Paul,

I see your solution, its good,

can you help enhance a little to include the qualifier 161 check as well pls?

Do you mean for 161 , I can put a nested func map too like 172?

Originally posted by: paul.brett

Yes, you would use the same trick to add another level / check for an additional tag.

See if you can make the change yourself, and post back your final solution here.

Thank-you.

Paul

Follow me on Twitter