Help :) Connect Tables

[farolito20]

I have two tables:

Table1:

     PartnerID,

     PartnerName

Table2:

     OrderID,

     PartnerID1,

     PartnerID2,

     Quantity

How can I connect both Partners from Table2 with Table1?

[#2]

Table1:

PartnerID,

PartnerName

Table2:

OrderID,

PartnerID1 as PartnerID,

PartnerID2,

Quantity

[farolito20]

What about PartnerID2?

[Anonymous]

Use mapping:

PartnerMap:
MAPPING LOAD DISTINCT
     PartnerID as A,
     PartnerName as B
RESIDENT Table1;

Drop Table Table1

Table2:
LOAD
OrderID,
applymap('PartnerMap',PartnerID1) as Partner1,
applymap('PartnerMap',PartnerID2) as Partner2,
...

[farolito20]

This only work with two fields?