topic Re: Need help linking columns together for 2 tables in QlikView

Need help linking columns together for 2 tables

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Need help linking columns together for 2 tables

sunny_talwar — Tue, 22 Mar 2016 20:31:00 GMT

Do you want explicitly join them into one table?

Re: Need help linking columns together for 2 tables

agustinbobba — Tue, 22 Mar 2016 21:03:16 GMT

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

Re: Need help linking columns together for 2 tables

Chanty4u — Wed, 23 Mar 2016 05:11:42 GMT

chk dis aswell

Generic keys

Re: Need help linking columns together for 2 tables

avinashelite — Wed, 23 Mar 2016 05:20:04 GMT

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

Re: Need help linking columns together for 2 tables

vikasmahajan — Wed, 23 Mar 2016 06:37:56 GMT

PFA document

HTH

Vikas

Re: Need help linking columns together for 2 tables

Wed, 23 Mar 2016 20:25:44 GMT

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