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?
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, 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
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 .
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 =(
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 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!
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....👍👍😊😊
Saved my day. Thank you so much.
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?
Thankyou ❤
Can you drop video of movement request transfer using uipath
Very useful . Thank you so much mam.
Hi Mam, May i know where can i learn the expressions/ syntax from the basics? (for eg: the assign expression u have used)
Please checkout below sessions -
ua-cam.com/video/Pt7Nb70n6Js/v-deo.html
ua-cam.com/video/bEmYPI_-xd4/v-deo.html
ua-cam.com/video/6_1WW4f7S4k/v-deo.html
ua-cam.com/video/OLVsf5lYdKs/v-deo.html
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, 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
Hello, this was very helpful. I am also interested in know who to lookup multiple fields. Thank you
Summary of workflow start 13:00min
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
This is resolved now ,as there was cell value space in DT .
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 .
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 =(
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
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.
Click on add headers