Need help linking columns together for 2 tables

[#1]

I am trying to form a relationship for 2 tables OrderH and OrderD for columns OURSO, Customer Number, and Invoice Date.

How should my load script look like to do this?

[sunny_talwar]

Do you want explicitly join them into one table?

[agustinbobba · Accepted solution]

Hi Sajid,

Something like that?

OrderH:
Load
  OURSO &'-'& [Customer Number] &'-'& [Invoice Date] AS Key,
  Field1,
  Field2,
  Field3
From OrderH ;


OrderD:
Load
  OURSO &'-'& [Customer Number] &'-'& [Invoice Date] AS Key,
  Field4,
  Field5,
  Field6
From OrderD;

Best Regards,

Agustín

[Chanty4u]

chk dis aswell

Generic keys

[avinashelite]

if you have many columns to be combined across 2 tables you could use JOIN , if you want to link the 2 tables using limited set of keys then you can form a composite a key ..

provide a sample data set that will help us to suggest  better 

[vikasmahajan]

PFA document

HTH

Vikas

[#7]

Hey guys I figured it out! Thanks a bunch for your help!