Keep related problem

[Anonymous]

Hi Everyone,

Here i'm facing problem . Actually i want to use keep in between two table .  Requirement is user wise amount, qty and tax .

Please anyone help me ..

Thanks

Master:

LOAD USER_ID,

     USERNAME,

     DealerCode,

     DealerName,

     State,

     City,

     Region,

     DealerType

FROM

MasterTable.xlsx

(ooxml, embedded labels, table is master);

Transaction:

LOAD USER_ID,

     DealerCode,

     DATE,

     Amount,

     Quantity,

     DealerType,

     Tax

FROM

Tab1.qvd

(qvd);

[er_mohit]

Try this

Master:

LOAD USER_ID &'|'&DealerCode&'|'&DealerType as Keylink,

USER_ID,

     USERNAME,

     DealerCode,

     DealerName,

     State,

     City,

     Region,

     DealerType

FROM

MasterTable.xlsx

(ooxml, embedded labels, table is master);

Transaction:

LOAD USER_ID &'|'& DealerCode&'|'&DealerType as Keylink,

     DATE,

     Amount,

     Quantity,

    // DealerType, //comment it

     Tax

FROM

Tab1.qvd

(qvd);

[#3]

hi

try this

Master:

LOAD

USER_ID & DealerCode as key,

USER_ID,

     USERNAME,

     DealerCode,

     DealerName,

     State,

     City,

     Region,

     DealerType

FROM

MasterTable.xlsx

(ooxml, embedded labels, table is master);

left keep

Transaction:

LOAD

USER_ID & DealerCode as key,

USER_ID,

     DealerCode,

     DATE,

     Amount,

     Quantity,

     DealerType,

     Tax

FROM

Tab1.qvd

(qvd);

[Anonymous]

Hi Vishwaranjan,

Thanks for the reply, but still the synthetic key is generating. Actually here we don't use the join as the requirement.

[kumarnatarajan]

Hi,

Remove folloing fiels in Transaction table.

DealerCode,

DealerType

Keep  Link field in trasaction look like mohit

[Anonymous]

Hi Niranjan,

Thanks for the reply. I have fixed the problem actually here there is no need of join or keep .

simply make combination of userid&dealercode as key in both table. Then on the basis of key both table would be connect in master table comment the userid and dealercode and in transaction table comment the dealertype.

Now both table would be connect and there is no synthetic key will generate.

Thanks