Forum Discussion
Correlate data
Please supply sample data and expected output.
mussaenda wrote:Please supply sample data and expected output.
I have employee number for example 12345 from Sharepoint online list and Employee name and Employee ID in another excel file (On same sheet, adjacent coloumn), Now I want to take out names correlating Employee number. Does it give clarity?
No. Please refer here.
Thank you
Based on my understanding from your explanation,
employee ID and employee number are the same?
if yes then create a relationship between two tables and use the employee number and put the employee name from your excel table.
Yes, you are right Employee number and ID are same. But I doesnt know how to create relationship to show Employee Name in reporting
Below data from a excel sheet
Sl.No GPN No Name 1 TR101 XXXX 2 TR101 YYY 3 TR101 ZZZZ 4 TR101 AAA 5 TR101 III 6 TR101 BBB 7 TR101 CCC 8 TR101 DDD Below image from Sharepoint online list (Empoyee ID = GPN number)
Image from sharepoint list, where Employee ID (GPN number) alone available
How do i correlate these data to show names in reports?
from your given data, what is your expected result?
elaborate more because I do not see any connection between the two data you provided.