I have two excel files, lets say EmpDetails1 and EmpDetails2
EmpDetails one has firstname, last name , fullname , i want to concatenate firstname and last name, add it to the Fullname Columns. How to achive this using linq??
Empdetail1 and EmpDetail2 has a common column, how to lookup these two columns using linq.
How to Concatenate and Lookup the values using linq in UIPath ??
If someone know the solution. Please suggest
Hi @supermanPunch I tried this, Its working.
Further i want to add this to full name column of excel file.
If i used loop to add it will take much time since data in excel is more than 50000 rows.
How to add all the data in single go. Is there any ways to do it .
Could you show what is the Schema or the Columns available in the other Excel sheet? So that we can understand if can perform a Join Operation using Join Datatables Activity and then preserve the required Columns.
You could also go ahead and use the Join Datatables Activity using the Common Column Names for the Join and let us know if you are able to achieve the result.