join qvd history with online load

[#1]

Hi Guys,

Script:

//name table as arvival
Arival:
LOAD Zeit,
Aus,
Gesellschaft,
Flugnr.,
Status,
Bemerkung
FROM "Online Location"

//get today date
let varToday = replace(now(),':','-');

//store data into filename with date
store Arival into c:\arival--$(varToday).qvd;

//join history with new online data
join (Arival)
LOAD Zeit,
Aus,
Gesellschaft,
Flugnr.,
Status,
Bemerkung
FROM
c:\arival--*.qvd]
(qvd);

Question:

How can I join my history from qvd with the 1st online load form online location and keep all duplicate records (show all history + new data), Iam not sure if my Join is the correct way to do this.

Thanks,

MIichiel

[maneshkhottcpl · Accepted solution]

Hi,

Use Concatenate between two table load.

e.q

load * from A:

concatenate

Load * from B

[tresesco]

Instead of JOIN, use CONCATENATE. Hope this helps you.

Regards, tresesco

[#4]

Hi Manesh, Tresesco,

Thank you, problem solved!

Michiel