topic Re: Identify Data coming from which QVD in QlikView

Identify Data coming from which QVD

ashishpalkar — Fri, 14 Aug 2015 12:08:57 GMT

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,

Re: Identify Data coming from which QVD

MK_QSL — Fri, 14 Aug 2015 12:10:24 GMT

While loading data from QVD add below in script..

FIleName() as FileName

Re: Identify Data coming from which QVD

maximiliano_vel — Fri, 14 Aug 2015 12:11:38 GMT

You could add an identifier column? Like

LOAD *,

'SourceA' as Source

FROM SourceA

For example?

Or you could use QUALIFY *;

Re: Identify Data coming from which QVD

swuehl — Fri, 14 Aug 2015 12:11:42 GMT

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.

Re: Identify Data coming from which QVD

ashishpalkar — Fri, 14 Aug 2015 20:34:42 GMT

Thanks for the update it worked as mentioned above.