Join Data tables

[Priya Bange]

Hi Experts,

I have 2 data tables on which need to joined together for further data processing like we do with SQL. I need to calculate CPU_Load_Each_Worker based on data supposedly in data tables like below. Am not sure how to do it with Linq

Join columns - Server_Name, Data_Center, Date, Task

Formula for CPU_Load_Each_Worker = CPU_Load/Total_Task_Count * Task_Count

Data Table 1

Server_Name Data_Center Date Task Total_Task_Count CPU_Load
Cloud_2001 TXS

20201804​

Spawn_Server

8​

45000​

Data Table 2

Server_Name Data_Center Date Task Worker_ID Worker_Name Worker_Center Task_Count
Cloud_2001 TXS

20201804​

Spawn_Server

1​

Worker_1 SG

2​

Cloud_2001 TXS

20201804​

Spawn_Server

2​

Worker_2 IND

1​

Cloud_2001 TXS

20201804​

Spawn_Server

3​

Worker_3 US

2​

Cloud_2001 TXS

20201804​

Spawn_Server

4​

Worker_4 UK

3​

Output Data Table 3

Server_Name Data_Center Date Task Worker_ID Worker_Name Worker_Center Task_Count CPU_Load_Each_Worker
Cloud_2001 TXS

20201804​

Spawn_Server

1​

Worker_1 SG

2​

1125​

Cloud_2001 TXS

20201804​

Spawn_Server

2​

Worker_2 IND

1​

562.5​

Cloud_2001 TXS

20201804​

Spawn_Server

3​

Worker_3 US

2​

1125​

Cloud_2001 TXS

20201804​

Spawn_Server

4​

Worker_4 UK

3​

1687.5​

Thanks in advance

Priya

Continue reading...