Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
thnx Abey..i got result by concatenating...:)