Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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);
all conditions in same table or in different tables?
Can you please elaborate the problem?
for each table conditions are different like wildmatch(AppicationID,"Operating System","Operating*"); for SEAL.
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.
thanks i will apply the same
it's fixed thanks
vikas