Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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;
Merhaba Sevda,
the label "data" is missing in the first line
regards
Bumin
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