Identify Data coming from which QVD

[ashishpalkar]

Hi There

I have 3 QVD's. Each QVD has different data sources.

Say QVD 1 -Data coming from A Source

Say QVD 2 -Data coming from B Source

Day QVD 2 -Data coming from C Source

In above QVD files, there is common ID no (Primary Key). When I want to display report along with ID and other QVD columns it should show from which QVD that ID belongs to.

Thanks,

[MK_QSL]

While loading data from QVD add below in script..

FIleName() as FileName

[maximiliano_vel]

You could add an identifier column? Like

LOAD *,

         'SourceA' as Source

FROM SourceA

For example?

Or you could use QUALIFY *;

[swuehl]

if you concatenate the data into one resident table, you can create an additional Source field in your LOAD:

LOAD *,

          'QVD1' as Source

FROM QVD1.qvd;

etc.

[ashishpalkar]

Thanks for the update it worked as mentioned above.