Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am trying to make a qvd with gets updated every day with its date
i.e. data to be concatenated with the previous qvd each day with every successive date with out repeating last day data
m trying this:
Tab1:
SQL
Select
Order No,
Ship_date as Link_date,
Order Quantity
From abc;
Noconcatenate
Tab2:
LOAD Order No,
Link_date,
Order Quantity
From abc;
CONCATENATE(Tab2)
LOAD *
RESIDENT tab1
where not exists(Link_date,Link_date);
Drop table tab1;
Data should come like below
link_date order no order quantity
09/12/2014 001 40
.
100 20
10/12/2014 101 100
300 400
11/12/2014 301 50
350 100
continued...
but concatenation is not happening
Please help me.......
I would do it something like this :
Table:
SQL
Select
Order No,
Ship_date as Link_date,
Order Quantity
From abc;
CONCATENATE (Table)
LOAD *
from YourQVD (qvd)
where not exists(Link_date);
Hi Durgesh,
please check for CONCATEANTE spelling.
replace with Concatenate.
Regards
Neetha
Hi,
Write some thing this way
//Load From SQL Server
Tab1:
SQL
Select
Order No,
Ship_date as Link_date,
Order Quantity
From abc;
//Concatenate latest updated records
Concatenate(Tab1)
LOAD *
From Excel
where not exists(Link_date,Link_date);
Drop table Tab1;
Regards
Anand
I don't see a qvd in your script,
one idea might be:
StoredData:
LOAD * FROM ......qvd (qvd);
AllData:
CONCATENATE (StoredDate) LOAD
*
WHERE NOT EXISTS(RelevantDate);
SQL SELECT * FROM ....;
STORE StoredData INTO ....StoredDate.qvd (qvd);
EXISTS might have to be adapted to required data, might be a date, might be a key-field.
HTH Peter