Replace Field content by "***" using Section Access different Users based on their NTID

[pradnya_amol]

Hello All,

Hope you all are safe in Lock Down!

I have a situation where my EAME Clients should see there EmpID and EmpName in "******" instead of Full ID and Name while for the rest these fields can be visible.

Needful fields from the Sample Data from the QVD:-

EMPID, EmpName, Region, CountryCode

E101,       Pradnya,   APAC, IN

E102,       Salman,   APAC, IN

E103,       Shahid,      EAME, FR

E104,       Ananya, EAME, HU

E105,       Alia,     EAME, FR

E106,       Aditya,  LATAM, PA

];

Section Access Code which I'm currently using in the Dashboard:-

TECC:
LOAD
ACCESS,
USERID,
Upper(Region) &'-'& Upper("Employee Country Code") as Region_Code_Key
FROM [lib://SharedFolder/Concur Excel/New Data/T&E Section Access.xlsx]
(ooxml, embedded labels, table is [PROD SA List]);

Concatenate(TECC)
LOAD Distinct 'DUMMY' as USERID,
Region_Code_Key
Resident Key;

SECTION Access;
STAR is *;
LOAD Distinct Upper(ACCESS) as ACCESS,
Upper(USERID) as USERID,
Region_Code_Key

Resident TECC;
SECTION Application;

DROP Table TECC;

EXIT SCRIPT

Sample from Excel File used for section access:-

ACCESS

USERID

Region

Employee Country Code

USER	APAC\s1005229	APAC	IN
USER	APAC\u897130	APAC	IN
USER	EAME\S952204	EAME	FR
USER	EAME\u971880	EAME	*

[marcus_sommer]

Take a look here: Mask or de-identify data for certain users using Section Access

- Marcus