ApplyMap() with multiple columns in the lookup file?

[#1]

Hi, how do I use ApplyMap with multiple columns in the lookup file?

MappingIdLkup	Category	Agreement
1001	Exchange Traded	Yes
1002	Over the Counter	No
1003	Exotics	No
1004	Exchange Traded	Yes
1005	Exchange Traded	Yes

I want to map ID and pull in both Category and Agreement as two columns.  But I don't want to have to use two separate Lookup files.

Is there an option in ApplyMap() that tells it to look in col1, col2, etc. when pulling in data?

Thanks

[Clever_Anjos]

An workaround is concatenate your desired fields

LOAD

    Category & Agreement as Search

    yourexpression

resident yourtable

[swuehl · Accepted solution]

No option like this.

You can use two maps or maybe a join instead.