Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have requirement like below. I have total six fields in Section Access. Region, SubRegion , Country , Customer, Division and Market.
And First 3 fields are loading from one QVD file and next 3 fields are loading from another QVD file.
I have put 'AND' Condition between two QVD files.
Region, SubRegion , Country AND Customer, Division , Market.
Because my requirement is 1st part I can give any one value for example Country=IN
2nd Part I can give any one value for example: Market= SMC
User has to see Country=IN and Market=SMC values.
Please tell me how can I put AND condition between two QVD's? or any alternative please
Section Access;
Access:
LOAD
"ACCESS",
"USERID",
LDAP_NAME,
STATIONKEY
FROM [lib://QVDs /ACCESS_CONCATENATED.qvd]
(qvd);
Access1:
LOAD
"ACCESS" as ACCESS1,
"USERID" as USERID1,
LDAP_NAME as LDAP_NAME1,
PARTNERKEY
FROM [lib://QVDs /ACCESS_CONCATENATED1.qvd]
(qvd);
Section Application;
ACCESS | USERID | LDAP_Name | Type | Region | SubRegion | Country | CorporatePartnerName | DivisionType | MarketGroup |
ADMIN | siboggar | Siva Boggrapu | Unrestricted | ||||||
USER | tahshaik | Tahreen | Restricted | VI | SMC | ||||
Hi Siva,
May be try like this:
Access:
LOAD
"ACCESS"&"USERID"&"LDAP_NAME" as %Key,
"ACCESS",
"USERID",
LDAP_NAME,
STATIONKEY
FROM [lib://QVDs /ACCESS_CONCATENATED.qvd]
(qvd);
join (Access)
LOAD
"ACCESS"&"USERID"&"LDAP_NAME" as %Key,
PARTNERKEY
FROM [lib://QVDs /ACCESS_CONCATENATED1.qvd]
(qvd);
Section Application;
Hi Siva,
May be try like this:
Access:
LOAD
"ACCESS"&"USERID"&"LDAP_NAME" as %Key,
"ACCESS",
"USERID",
LDAP_NAME,
STATIONKEY
FROM [lib://QVDs /ACCESS_CONCATENATED.qvd]
(qvd);
join (Access)
LOAD
"ACCESS"&"USERID"&"LDAP_NAME" as %Key,
PARTNERKEY
FROM [lib://QVDs /ACCESS_CONCATENATED1.qvd]
(qvd);
Section Application;
Hi,
Am not sure I understand what you meant by AND between the QVDs. Do you mean join the QVDs together?
If you wanted to join the 2 qvds together, then you need field(s) with same name from the 2 qvds to be able to join and have 1 table for your ACCESS.
Example:
Section Access;
Access:
LOAD
"ACCESS",
"USERID",
LDAP_NAME,
STATIONKEY
FROM [lib://QVDs /ACCESS_CONCATENATED.qvd]
(qvd);
//Access1:
LEFT JOIN(Access)
LOAD
"ACCESS" ,
"USERID" ,
LDAP_NAME ,,
PARTNERKEY
FROM [lib://QVDs /ACCESS_CONCATENATED1.qvd]
(qvd);
Let me know if it helps