Section access

[sivaboggarapu20]

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

[jyothish8807 · Accepted solution]

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;

[Gabriel]

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

[sivaboggarapu20]

Hi,

Thanks for reply.

I have requirement like for example from my table(Please look at the above table)
user: Tahshail has to see Country=VI and what are the Market Groups(SMC) available under country =VI

Coutry=VI is one QVD file and Market Group(SMC) is one QVD file

I need make AND Condition between two QVD files

OR else is there any alternative please?

Thanks,
Siva