Correlate data

[Anonymous]

I have employee number from Sharepoint list and Name and Employee number from a excel. How can I show a report with Name and number of tasks raised by each person by correlating both the data sources?

[mussaenda]

Please supply sample data and expected output.

[Anonymous]

---

@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?

[mussaenda]

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.

[Anonymous]

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?

[mussaenda]

from your given data, what is your expected result?

elaborate more because I do not see any connection between the two data you provided.

[Anonymous]

I want to take out names against GPN number.... I want to build a report on howmany task raised or completed by each employee with names and not with Number as it will be difficult to recognise names with numbers