WHERE.... garbage after statement ERROR

[#1]

HI ALL,

This produces the dreaded "Garbage after statement...." ....Am not I concatenating the new data with qvd.

LOAD date(gun) as gun,
sayı
FROM
a.xlsx
(ooxml, embedded labels, table is Sayfa1);
store data into data.qvd;
data:
LOAD gun,
     sayı
FROM
data.qvd
(qvd);
max_gun:
load date(max(gun)) as max
Resident data;
let vmax=Peek('max',0,'max_gun');
drop table data;
NoConcatenate
Incremental:
LOAD gun,
     sayı
From
a.xlsx
(ooxml, embedded labels, table is Sayfa2)
where gun>= $(vmax);
Concatenate
LOAD date(gun) as gun,
     sayı
FROM
data.qvd
(qvd)
where not Exists(sayı);
store Incremental into data.qvd(qvd);
drop Table Incremental;

Any ideas? PLEASE HELP!!!

[swuehl]

Maybe like this:

data:

LOAD date(gun) as gun,

sayı

FROM

a.xlsx

(ooxml, embedded labels, table is Sayfa1);

store data into data.qvd;

data:

LOAD gun,

     sayı

FROM

data.qvd

(qvd);

max_gun:

load date(max(gun)) as max

Resident data;

let vmax=Peek('max',0,'max_gun');

drop table data;

Incremental:

NoConcatenate

LOAD gun,

     sayı

From

a.xlsx

(ooxml, embedded labels, table is Sayfa2)

where gun>= '$(vmax)';

Concatenate

LOAD date(gun) as gun,

     sayı

FROM

data.qvd

(qvd)

where not Exists(sayı);

store Incremental into data.qvd(qvd);

drop Table Incremental;

[bumin]

Merhaba Sevda,

the label "data" is missing in the first line

regards

Bumin

[agilos_mla]

Which QV version are you running?

I didn't see any suspicious things and your script then I run on my 11.2 SR5 and it's ok. (excepted a "Data:" at the beginning, probably misse in the copy/paste?)

Michael