How to find which QVD has a number that we are looking for

[qvqfqlik]

How to find which QVD has the values/numbers

I have like 10 extract scripts all are same, but each of them processing different set of orders.

I want to find from the QVDs - which order is coming from which QVD ?

Please help

[trdandamudi]

You can use filebasename() or filename() in your load statement.

Example:

Load *, filebasename( ) as Filename from

C:\UserFiles\abc.txt

Will return 'abc' in field Filename in each record read.

For qvd:

Load *, filename( ) as Filename from

C:\UserFiles\abc.qvd

Will return 'abc.qvd' in field Filename in each record read.

Hope this helps,,,

[qvqfqlik]

My test code is here. I have QVDs with naming  abc_1,....abc_10.

I want to know which PO is coming which QVD(which PO belongs to which QVD)

several PO's are split into these 10 QVDs.

LOAD

     field1,field2,PO

FROM

c:\folder\abc_*.qvd (qvd)

Where Match([PO],'111','123','145');

[trdandamudi]

May be as below:

LOAD

     field1,field2,PO,

      Filename () as Filename

FROM

c:\folder\abc_*.qvd (qvd)

Where Match([PO],'111','123','145');

[qvqfqlik]

Thanks

[oknotsen]

If your question is now answered, please flag the Correct Answer.

If not, please let us know with which part of this topic you still like some help .