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

This video explains how to compare two excel sheets and update the cells according to excel comparison results, using Lookup data table Activity

=========================================================

Automation Anywhere Tutorial Playlist:

Automation Anywhere A2019 Tutorial Playlist:

UiPath Tutorial Playlist:

JMeter Tutorial Playlist:

Git and GitHub Tutorial Playlist:

[QAAutomationLab]

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!

[mokindbhosle]

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

[zishansk]

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

[ViveksaiKurugodu]

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?

[Dineshkumar]

Can you drop video of movement request transfer using uipath

[mrsjaya]

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?

[Praveenkumar-jfzl]

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

[sudhanshuvats]

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

[digvijaysingh]

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

[douglasflores]

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 =(

[vikassaini]

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

[DeepakKumar-ovxp]

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

[DeepakKumar-ovxp]

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 .

[DeepakKumar-ovxp]

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



Please help if i need to share any more info.