Resident Load what is wrong in below script

Thu, 02 Apr 2015 07:35:39 GMT

BINARY C:\DATA_12_MONTHS.qvw;

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';

FACT_DATA_1:

LOAD *

RESIDENT FACT_DATA

WHERE DateKey= 20150301;

DROP TABLE FACT_DATA;

Hey Guys,

What is wrong with above script?

DATA_12_MONTHS.qvw having a fact table FACT_DATA with 12 months data and I am trying to reduce it to one day data and load into FACT_DATA_1. But this is not working as expected.

1-It is not creating table FACT_DATA_1..?

2- WHERE DateKey= 20150301 filter is not working?

Re: Resident Load what is wrong in below script

Anonymous — Thu, 02 Apr 2015 07:40:07 GMT

Try adding a NoConcatenate

FACT_DATA_1:

NoConcatenate

LOAD *

RESIDENT FACT_DATA

WHERE DateKey= 20150301;

DROP TABLE FACT_DATA;

Re: Resident Load what is wrong in below script

sushil353 — Thu, 02 Apr 2015 07:40:11 GMT

Hi,

Use noconcatenate function before your load.

HTH

Sushil

topic Re: Resident Load what is wrong in below script in QlikView

Resident Load what is wrong in below script

Re: Resident Load what is wrong in below script

Re: Resident Load what is wrong in below script