Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any one could help me on how to combine 2 condition access for country and Business Unit ? i manage to do both if not combine however if i try to combine my qlikview file could't open. please advise on this. Thanks
example code i done:
//UAM: First condition
//LOAD UPPER(ACCESS) AS ACCESS,
// ATTRIBUTE AS ATTRIBUTE,
// UPPER(NTNAME) AS NTNAME,
// UPPER(DATAVALUE) AS DATAVALUE,
// IF((ATTRIBUTE)='......',UPPER(DATAVALUE))AS REGION
//FROM
//[..\..\..UAM.xlsx]
//STAR is *;
//Section Access;
//Section_Access:
//LOAD DISTINCT UPPER(ACCESS) AS ACCESS,
// UPPER(NTNAME) AS NTNAME,
// DATAVALUE,
// UPPER(REGION) AS REGION
//Resident UAM where ATTRIBUTE='.....';
//Concatenate (Section_Access)
//LOAD * INLINE [ ACCESS, NTNAME, REGION
// ADMIN, ..... ];
//Section Application;
//Access:
//LOAD * INLINE [
//REGION, Country
//CHINA, China
//..., .....];
//DROP Table UAM;
BU:
LOAD UPPER(ACCESS) AS ACCESS,
ATTRIBUTE AS ATTRIBUTE,
UPPER(NTNAME) AS NTNAME,
IF((ATTRIBUTE)='......',UPPER(DATAVALUE))AS BU
FROM
[..\..\..\UAM.xlsx]
where ATTRIBUTE='.....';
STAR is *;
Section Access;
Section_AccessBU:
LOAD DISTINCT UPPER(ACCESS) AS ACCESS,
UPPER(NTNAME) As NTNAME,
UPPER(BU) AS BU
Resident BU where ATTRIBUTE='....';
Concatenate (Section_AccessBU)
LOAD * INLINE [ ACCESS, NTNAME, BU
ADMIN, ... ];
Section Application;
Access2:
LOAD * INLINE [
BU, 'PPS Business Segments'
PC, PC
HARDWARE,Hardware];
DROP Table BU;
DATA:
LOAD
//IF(ALIAS='REGION' OR ALIAS='Region',DATAVALUE)AS Country ,
IF(ALIAS='BU',DATAVALUE)AS [PPS Business Segments] ,
FROM
[..\..\..UAM.xlsx]
SHIP:
LOAD
COUNTRY as Country,
[PPS Business Segments],
REMARKS,
FROM
SHIPMENT.xls