Load data from QVD with multiple conditions

[vikasmahajan]

Dear All,

I have  following 3 tables in qvd

MARS:

Host_Name,

.

.

from Mars.QVD (qvd);

TAMS:

Host_Name,

Product_Type,

...

ApplicationID

from TAMS.QVD (qvd);

SEAL:

Application ID

...

...

From SEAL.QVD (qvd);

I want to join this qvds with condition AppicationID='Operating System'  there are so many conditions like application id.

In this scenario what I have to do ?

Please share idea ?

Thanks in adv.

Vikas

[_rohitgharat]

Dear Vikas,

               First of all load all three tables seperately using where condition  (i.e AppicationID='Operating System' ) and then join them. I hope it will work

Regards,

Rohit

[kumarnatarajan]

Hi Vikas,

See the below example it may help you.

Ex:

SEAL:

Application ID

...

...

From SEAL.QVD (qvd)

where wildmatch(AppicationID,"Operating System","Operating*");

Left Join(SEAL)

TAMS:

Load

AppicationID,

......,

......,

from TAMS.QVD (qvd);

Left Join(SEAL)

MARS:

Host_Name,

.

.

from Mars.QVD (qvd);

[PradeepReddy]

all conditions in same table or in different tables?

Can you please elaborate the  problem?

[vikasmahajan]

for each table conditions are different  like  wildmatch(AppicationID,"Operating System","Operating*"); for SEAL.

[PradeepReddy · Accepted solution]

TAMS:

Host_Name,

Product_Type,

...

ApplicationID

from TAMS.QVD (qvd)

where condition1 and condition2;

Left join(TAMS):

Host_Name,

...

from Mars.QVD (qvd)

where condition3 and condition4;

Left join(TAMS)

SEAL:

Application ID

...

From SEAL.QVD (qvd)

where condition5 and condition6;

Other way is...

during the data extraction from DB only, apply all these filters in SQL query.  Then perform the necessary operation in qlikview.

[vikasmahajan]

thanks i will apply the same

[vikasmahajan]

it's fixed thanks

vikas