I have two datatables like
The first one is last month’s data and the second one is current month data. I am splitting the current month data based on location so, since there is only Mumbai in current month, I will have an Excel file having both the records.
Now, I must get the transfer from and transfer to for all employees.
So, in Mumbai for A it’s transfer from Chennai I got this right, it’s working perfectly
For transfer to also it’s working fine (It must create a file in Chennai location with the Employee’s new location but, it’s creating the file in Mumbai location itself) What have I done wrong?