Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I have 3 tables which has the Employee ID common and which is the connector.
Now I want to list the unmatched details across 3 tables based on my key.
Could you please suggest an idea.
Thanks & Regards
Jeba
T1:
Mapping LOAD
Emp_ID & Name as Key,
Emp_ID & Name as Flag
FROM
[EMP Data.xlsx]
(ooxml, embedded labels, table is Table1);
Final:
LOAD
IF(ApplyMap('T1',Emp_ID&Name,'NO')='NO',Emp_ID) as NoEmp_ID,
IF(ApplyMap('T1',Emp_ID&Name,'NO')='NO',Name) as NOName,
Emp_ID,
Name
(ooxml, embedded labels, table is Table2);
(ooxml, embedded labels, table is Table3);
T2:
Mapping Load
Resident Final;
IF(ApplyMap('T2',Emp_ID&Name,'NO')='NO',Emp_ID) as NoEmp_ID,
IF(ApplyMap('T2',Emp_ID&Name,'NO')='NO',Name) as NOName,
======================
Now Create a table box with
NoEmp_ID and NOName as dimension
Presentation tab and select NoEmp_ID and Tick Omit Rows When Field is NULL
View solution in original post
Can you provide little sample data?
Hi Manish,
Please find attached the sample data.
I have highlighted the values I want to list.
Kindly help
Hi.
To check whether particular Employee ID is contained in a table, you can use Employee ID as dimension and count some value from the desired table. If count >0 then Employee ID is contained in the table.
My Employee ID field name is same across 3 tables.How to call the specific?
May be like attached sample?
Actually if the field is common there is only one Employee ID that has indexes in three tables.
Could you just try ? Create chart with one dimension Employee ID and add three count expression that use fields from different tables.
Thanks Manish,It worked perfectly
