Concatenating 4 QVD's

Tue, 20 Jul 2010 16:23:51 GMT

Below is my QVD script. I am concatenating 3 QVD's with the first QVD which I name PT_Data. When the script executes, I only get records for the 1st QVD.

What do I need to do to append the other 3 QVD's

Thanks

Glen

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

PT_Data:

LOAD MT_VISIT,

AdmitDateTime,

Disch_Date,

LOS,

FacilityName,

FAC_INS,

InpatientOrOutpatient,

PatientID,

InsuranceID,

Month,

Year,

TYPE,

F_NAME,

REGION,

INS_NAME,

AdjustmentTotal,

BAL,

BarStatus,

CHARGES,

RECEIPTS,

REFUNDS

FROM

EH.qvd

(qvd);

Concatenate ("PT_Data")

LOAD MT_VISIT,

AdmitDateTime,

Disch_Date,

LOS,

FacilityName,

FAC_INS,

InpatientOrOutpatient,

PatientID,

InsuranceID,

Month,

Year,

TYPE,

F_NAME,

REGION,

INS_NAME,

AdjustmentTotal,

BAL,

BarStatus,

CHARGES,

RECEIPTS,

REFUNDS

FROM

NH.qvd

(qvd);

Concatenate ("PT_Data")

LOAD MT_VISIT,

AdmitDateTime,

Disch_Date,

LOS,

FacilityName,

FAC_INS,

InpatientOrOutpatient,

PatientID,

InsuranceID,

Month,

Year,

TYPE,

F_NAME,

REGION,

INS_NAME,

AdjustmentTotal,

BAL,

BarStatus,

CHARGES,

RECEIPTS,

REFUNDS

FROM

SB.qvd

(qvd);

Concatenate ("PT_Data")

LOAD MT_VISIT,

AdmitDateTime,

Disch_Date,

LOS,

FacilityName,

FAC_INS,

InpatientOrOutpatient,

PatientID,

InsuranceID,

Month,

Year,

TYPE,

F_NAME,

REGION,

INS_NAME,

AdjustmentTotal,

BAL,

BarStatus,

CHARGES,

RECEIPTS,

REFUNDS

FROM

SW.qvd

(qvd);

Concatenating 4 QVD's

lblancher — Tue, 20 Jul 2010 16:47:08 GMT

Hi,

From a quick look at your script, can you replace the Concatenate("PT_Data") with Concatenate(PT_Data). You don't need to wrap your table name in quotes.

Lucas Blancher

BizXcel Inc.

www.bizxcel.com

Concatenating 4 QVD's

Tue, 20 Jul 2010 16:51:43 GMT

Thanks

That did it.

topic Concatenating 4 QVD's in QlikView

Concatenating 4 QVD's

Concatenating 4 QVD's

Concatenating 4 QVD's