Correlate data

Question

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 · Answer

Please supply sample data and expected output.

anonymous · Answer

mussaenda&nbsp;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 · Answer

No. Please refer here.Thank you&nbsp;Based on my understanding from your explanation,employee ID and employee number are the same?&nbsp;if yes then create a relationship between two tables and use the employee number and put the employee name from your excel table.

anonymous · Answer

Yes, you are right Employee number and ID are same. But I doesnt know how to create relationship to show Employee Name in reportingBelow data from a excel sheetSl.NoGPN NoName1TR101XXXX2TR101YYY3TR101ZZZZ4TR101AAA5TR101III6TR101BBB7TR101CCC8TR101DDD&nbsp;Below image from Sharepoint online list (Empoyee ID = GPN number)Image from sharepoint list, where Employee ID (GPN number) alone available&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;How do i correlate these data to show names in reports?

mussaenda · Answer

from your given data, what is your expected result?elaborate more because I do not see any connection between the two data you provided.

Forum Discussion

Correlate data

6 Replies

Related content

Correlation matrix

correlation matrix / plot

Data Correlation

Creating Correlation

Determine Correlation