get records from qvd

[#1]

Hi Folks,

I have a situation here:

I have set of orders for different cities. Each order has three status complete, draft and void. The data exists in the qvd.

Now for all cities I wish to get the orders in status complete but for only for 1 city say Delhi I wish to get the orders in status complete and draft both.

How do i get this done?

Help much appreciated.

Thank you.

[its_anandrjs · Accepted solution]

Hi,

Try to create the resident table to get the data in order status complete, draft and void

Source:

Load

Orders,

City,

status

From Source;

Noconcatenate

Load

Orders,

City,

status

From Source

Order By Match(status,'complete', 'draft','void');

Drop table Source;

Or

Source:

Load

Orders,

City,

status

From Source;

Noconcatenate

Load Orders,City,status

From Source where Match(status,'complete');

Concatenate

Load Orders,City,status

From Source where Match(status, 'draft');

Concatenate

Load Orders,City,status

From Source where Match(status,'void');

Drop table Source;

Regards

Anand