topic Creation of Composite Key in QlikView

Creation of Composite Key

raghavsurya — Wed, 10 Sep 2014 13:58:04 GMT

Hi,

I am trying to join 2 tables along with creating a composite key. I am using below script and on reloading, the application throws out an error at composite key creation line. Please help me. Below is the script being used:

BILLDETAILS:

SELECT

BILLDETAILS.BILLNUMBER,

BILLDETAILS.BILLTYPE,

BILLDETAILS.BILLDETAILSLNO,

BILLDETAILS.BILLNUMBER & BILLDETAILS.BILLTYPE & BILLDETAILS.BILLDETAILSLNO as BillDetailKey,

BILLDETAILS.BILLMASTERREFERENCE,

BILLDETAILS.BILLCATEGORYCODE,

CATEGORYMASTER.CATEGORYNAME,

SUPPLIERMASTER.COMPANYNAME,

USERMASTER.USERFULLNAME

FROM BILLDETAILS

Left Outer Join CATEGORYMASTER on (BARCODEDITEMS.CATEGORYID = CATEGORYMASTER.CATEGORYID)

Left Outer Join SUPPLIERMASTER on (BARCODEDITEMS.SUPPLIERCODE = SUPPLIERMASTER.COMPANYCODE)

Left Outer Join USERMASTER on (BARCODEDITEMS.BARCODEDUSERNAME = USERMASTER.USERNAME);

BILLSTONEDETAILS:

Select

BILLSTONEDETAILS.BILLNUMBER,

BILLSTONEDETAILS.BILLTYPE,

BILLSTONEDETAILS.BILLDETAILSLNO,

BILLSTONEDETAILS.BILLNUMBER & BILLSTONEDETAILS.BILLTYPE & BILLSTONEDETAILS.BILLDETAILSLNO as BillDetailKey,

BILLSTONENUMBERS,

BILLSTONEWEIGHT,

BILLSTONERATE

FROM BILLSTONEDETAILS

Re: Creation of Composite Key

MarcoWedel — Wed, 10 Sep 2014 18:48:22 GMT

Try preceding LOAD:

BILLDETAILS:

LOAD *,

BILLDETAILS.BILLNUMBER & BILLDETAILS.BILLTYPE & BILLDETAILS.BILLDETAILSLNO as BillDetailKey;

SELECT

BILLDETAILS.BILLNUMBER,

BILLDETAILS.BILLTYPE,

BILLDETAILS.BILLDETAILSLNO,

BILLDETAILS.BILLMASTERREFERENCE,

BILLDETAILS.BILLCATEGORYCODE,

CATEGORYMASTER.CATEGORYNAME,

SUPPLIERMASTER.COMPANYNAME,

USERMASTER.USERFULLNAME

FROM BILLDETAILS

Left Outer Join CATEGORYMASTER on (BARCODEDITEMS.CATEGORYID = CATEGORYMASTER.CATEGORYID)

Re: Creation of Composite Key

maxgro — Wed, 10 Sep 2014 20:35:42 GMT

BILLDETAILS:

load

BILLDETAILS.BILLNUMBER & BILLDETAILS.BILLTYPE & BILLDETAILS.BILLDETAILSLNO as BillDetailKey,

;

SQL SELECT

BILLDETAILS.BILLNUMBER,

BILLDETAILS.BILLTYPE,

BILLDETAILS.BILLDETAILSLNO,

BILLDETAILS.BILLMASTERREFERENCE,

BILLDETAILS.BILLCATEGORYCODE,

CATEGORYMASTER.CATEGORYNAME,

SUPPLIERMASTER.COMPANYNAME,

USERMASTER.USERFULLNAME

FROM BILLDETAILS

Left Outer Join CATEGORYMASTER on (BARCODEDITEMS.CATEGORYID = CATEGORYMASTER.CATEGORYID)

Left Outer Join SUPPLIERMASTER on (BARCODEDITEMS.SUPPLIERCODE = SUPPLIERMASTER.COMPANYCODE)

Left Outer Join USERMASTER on (BARCODEDITEMS.BARCODEDUSERNAME = USERMASTER.USERNAME);

BILLSTONEDETAILS:

load

BILLSTONEDETAILS.BILLNUMBER & BILLSTONEDETAILS.BILLTYPE & BILLSTONEDETAILS.BILLDETAILSLNO as BillDetailKey,

BILLSTONENUMBERS,

BILLSTONEWEIGHT,

BILLSTONERATE;

SQL Select

BILLSTONEDETAILS.BILLNUMBER,

BILLSTONEDETAILS.BILLTYPE,

BILLSTONEDETAILS.BILLDETAILSLNO,

BILLSTONENUMBERS,

BILLSTONEWEIGHT,

BILLSTONERATE

FROM BILLSTONEDETAILS;