I am not using qlikview script editor.. so if there is any small syntax missing correct that.. but the below should work:
Mapping Load id & '|' & state & '|' & client as MapID,
admin as MapValue
Load Applymap ('MapIDs', id & '|' & state & '|' & client , null()) as admin,
I am considering that you already have loaded table1 and table2 earlier. use concatenate or noconcatenate according to when you are loading these tables etc.