Concatenating rows with existing qvd not having data of previous day

[durgesh25]

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.......

[Anonymous]

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);

[Anonymous]

Hi Durgesh,

please check for CONCATEANTE spelling.

replace with Concatenate.

Regards

Neetha

[its_anandrjs]

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

[prieper]

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