Issue with Store function

Wed, 22 Jan 2014 15:14:46 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'; SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

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

[Overview]:

LOAD

sec_acct_hldg_id as sec_acct_hldg_id1 ,

DQ_Dimension

FROM

[.......\Exceptions_New_Dec.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[Overview]:

LOAD sec_acct_rec_id

FROM

[...........................\Main_Dataset_Dec.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Final:

LOAD sec_acct_hldg_id1,

DQ_Dimension,

sec_acct_rec_id;

store Final into .....................\Final.qvd

The Error MSG I get is....

Table not found

store Final into .....................\Final.qvd

Re: Issue with Store function

Nicole-Smith — Wed, 22 Jan 2014 15:16:18 GMT

Change:

Final:

LOAD sec_acct_hldg_id1,

DQ_Dimension,

sec_acct_rec_id;

To:

Final:

NOCONCATENATE LOAD sec_acct_hldg_id1,

DQ_Dimension,

sec_acct_rec_id;

Since Final has the same fields as Overview, it's concatenating them together.