UiPathTutorial 29-Compare two excel sheets and update the cells |Lookup Data Table |Excel Comparison

Hi, thanks for video, can you please suggest if there are two table with 45 columns and i have to update old data with new for all column, so do we have to use 45 lookup or there is another way, please share your view

I had a problem when i try, if i have 2 same name in EmployeeName (duplicated Row with one designated in sheet 2 and the other not) they don't work, they follow the config like equal the other =(

Do you have a video to demp comparing two columns from excel 1 to two columns in excel 2 and updating excel 1 with data from excel 2 if match is found?

Hi Mam, May i know where can i learn the expressions/ syntax from the basics? (for eg: the assign expression u have used)

Hi Madam Good Afternoon.Hope you are doing good.I am facing error message while executing same case .Below i have provided details.
Getting error {
"message": "Assign: Column 'UpdateDesignation' does not belong to table DataTable."

Eventhough column 'UpdateDesignation' belong to correct Datatable.



ReadRange 1st Sheet o/t=DTMaster
ReadRange 2ND Sheet o/t=DTUpdate
ReadRange 1st Sheet o/t=ResultMasterDT

For each row in DTMaster Datatable ,Row Index:RowIndex1

Lookup Data table
DataTable :2nd sheet -DTUpdate
Lookup Value:row("Employee Name").ToString
Coloum Name:"Employee Name"
Row Index:RowIndex2

If RowIndex2 <> -1

ResultMasterDT.Rows(RowIndex1).item("Designation")=DTUpdate.Rows(RowIndex2).item("UpdateDesignation")

Please help if i need to share any more info.

Hi Madam Good Evening-Sharing log message :RemoteException wrapping System.ArgumentException: Column 'UpdatedDesignation' does not belong to table DataTable.
If you get's chance to look into my issue ,please suggest to resolve this issue & i will able to share additional info if required.Thanks .

This is resolved now ,as there was cell value space in DT .

Very useful . Thank you so much mam.

Hi,
I am getting an error in for each row datatable
"Non invocable member currentrow cannot be used like a method.
Can you help me to rectify it

thank you so much ma'am love the way you explained it so prettiest way. never ever saw presentation like this

Thank you so much Mam for such wonderful and informative video....👍👍😊😊

Can you drop video of movement request transfer using uipath

Saved my day. Thank you so much.

mam you provide paid training if you provide paid training i am ready to paid you for the training please reply for providing valuable lecture

Thankyou ❤

Hello ma'm,
Good explanation.
I am doing the same scenario as you said
But there is some complexity I am facing with modern mandatory fields.
In the column number field it suggested for column index.
In the video by the time you made the video there is no option.
Could you please suggest what to give in the column number field?

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!