problem in linking table.

Thu, 12 Sep 2013 12:51:46 GMT

Hi all..

I have two QVW with almost identical column. table 1 contain data above 25 lakh invoices and second table cintain data above 1 crore invoices.

i have to merge both into one.

I am attaching code here.

LOAD CUSTOMER_REF,

     PROVIDER_ID_TCLi_Attributes,

     BILLING_ENTITY,

     CUID,

     SECS_ID,

     DEFAULT_CURRENCY

FROM

E:\Qlikview\QV_Database\Geneva\Merge_app_qvd\TCLi_Attributes.qvd

(qvd);

BILLSUMMARY_b:

LOAD ACCOUNT_NUM,

     INVOICE_NUM,

     CUSTOMER_REF,

     ACCOUNT_NUM & CUSTOMER_REF as key1,

     CONTACT_SEQ,

     INV_FILE_NAME,

     BILL_SEQ,

     ACTUAL_BILL_DTM,

     TOTAL_INVOICE_VALUE,

     INVOICE_NET_MNY,

     INVOICE_TAX_MNY,

     TYPE_OF_INVOICE,

     TAXAMOUNT_US_CANADA,

     Billing_Currency,

     Info_Currency,

     SERVICE_TYPE,

     PROVIDER_ID,

     CUSTOMER_SEGMENT,

     CONTACT_PERSON,

     ADDRESS_NAME,

     ACCOUNTING_CODE,

     ConversionRate

FROM

E:\Qlikview\QV_Database\Geneva\Merge_app_qvd\BILLSUMMARY_b.qvd

(qvd);

Concatenate

LOAD ACCOUNT_NUM,

     INVOICE_NUM,

     CUSTOMER_REF,

     ACCOUNT_NUM & CUSTOMER_REF as key1,

     CONTACT_SEQ,

     INV_FILE_NAME,

     BILL_SEQ,

     ACTUAL_BILL_DTM,

     INVOICE_NET_MNY,

     INVOICE_TAX_MNY,

     TYPE_OF_INVOICE,

     FLAG,

     TAXAMOUNT_US_CANADA,

     Billing_Currency,

     Info_Currency,

     SERVICE_TYPE,

     PROVIDER_ID,

     CUSTOMER_SEGMENT,

     ACCOUNTING_CODE,

     CONTACT_PERSON,

     ADDRESS_NAME,

     ConversionRate

FROM

E:\Qlikview\QV_Database\Geneva\Merge_app_qvd\TABLE2.qvd

(qvd);

i have to merge all above to get one report which shows both 25 lkha above invoices and 1 crore above also.

any help is appreciated.

Re: problem in linking table.

abeyphilip — Thu, 12 Sep 2013 14:13:54 GMT

Hi Monica,

There are 3 loads in what you have posted.

I suppose you don't want to merge the data from TCLi_Attributes.qvd but from TABLE2.qvd and BILLSUMMARY_b.qvd in to a single table.

Are you getting any error while load?

Meanwhile can you try adding noconcatenate before load for BILLSUMMARY_b and see if it achieves what you want?

Regards,

Abey

Re: problem in linking table.

Fri, 13 Sep 2013 06:53:01 GMT

thnx Abey..i got result by concatenating...:)

topic Re: problem in linking table. in QlikView

problem in linking table.

Re: problem in linking table.

Re: problem in linking table.