topic matching employees in qlikview in Integration, Extension & APIs

matching employees in qlikview

capriconuser — Fri, 20 Aug 2021 06:32:01 GMT

i have server employee list in excel sheet .. and i load data like this

Employee: LOAD EmpID, lower(SUBFIELD([Email ID],'@',1)) AS EmailID FROM [data\EmpList\EList*.xlsx] (ooxml, embedded labels, table is [Sheet - 1]);

and the other table is

BoxUsage: LOAD DisplayName as FullName, lower(SUBFIELD(EmailAddress,'@',1)) AS EmailID, left(Usage, Index(Usage, 'B')) as C_InUnits, CurrentSize, MailMonth, MailYear FROM [data\Mail Box Usage\MUsage-*.xlsx] (ooxml, embedded labels, table is Sheet1); left Join(Employee) LOAD * Resident BoxUsage; Drop table BoxUsage;

So here 2 table is link with EmailID.. and all data of BoxUsae now in employee table and i want only those emailID in straight table which is in Employeetable ... in BoxUsage some emails starts from upper case but in employee table all emails start with lower case ... so i want only which start from lower case ..

but now i get data also upper case.

how i resolve it.. 2

Re: matching employees in qlikview

MayilVahanan — Fri, 20 Aug 2021 08:53:02 GMT

Try like below

Employee:
LOAD

EmpID,
lower(SUBFIELD([Email ID],'@',1)) AS EmailID,

1 as EmpEmailFlag

FROM
[data\EmpList\EList*.xlsx]
(ooxml, embedded labels, table is [Sheet - 1]);

In straight table, in exp, try like below

Dim: EmailID

Count({<EmpEmailFlag={1}>}urexpression)

<-- its gives only employee table email info

Re: matching employees in qlikview

capriconuser — Fri, 20 Aug 2021 11:13:36 GMT

@MayilVahanan i am also adding columns from MUsage.. is there any method except putting flag

and also now all columns plus MUsage table columns also in employee table

Re: matching employees in qlikview

MayilVahanan — Fri, 20 Aug 2021 15:37:10 GMT

Flag is for indication whether the value is coming from this table or not. you can add columns from MUsage table also in the same table