Resident Load what is wrong in below script

[#1]

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?

[Anonymous · Accepted solution]

Try adding a NoConcatenate

FACT_DATA_1:

NoConcatenate

LOAD *

RESIDENT FACT_DATA

WHERE DateKey= 20150301;

DROP TABLE FACT_DATA;

[sushil353]

Hi,

Use noconcatenate function before your load.

HTH

Sushil