Hi Mukesh ji, I was able to understand the flow of reconci and sucessfully coded the ran sucessfully. The explanatio is too good and very much easy to nderstand. you explan very well.
Excellent Video sir. Complete and Concise presentation of Data table concepts, Invoke Workflow activity, For each Row, etc. Lengthy powerful content video. Very neat presentation.
Bro in 2nd used cases for comparing and writing data first i take for each loop and iterate Source datatable after that in body i used LINQ query in if condition "(From NewDt in MasterDT where main(1).ToString.Trim.Equals (NewDt(0).toString.trim) Select NewDt).ToArray.count>0" after that store this value in one data table resultdt =(From NewDt in MasterDT where main(1).ToString.Trim.Equals (NewDt(0).toString.trim) Select NewDt).Copytodatatable after that i take assign activity and assign the value in source data table by writing source(9)=result(0)(3).tostring. Execution time of workfkow only 2 sec.
Perfect ! That should be Your approach to compare the 2 DataTable. This Video I had made keeping in mind of Beginners. Also to Match and Paste Data we can use LINQ. If you can comment the exact LINQ and the steps you followed - Happy to PIN the Comment for the Viewers.
1. Either Source of Destination Files are Missing - Inform Business by sending Mail 2. Application required to extract Data are Not Responding or failed to Open - close Everything and Reopen Application 3.Formats of Data is different in both Data Sets - Inform the Senders about the Formats 4. No Common Field to Compare - Inform the Senders about the Formats. 5. while Sending Summary - Exception in Sending Mail - Handle outlook exceptions
Hello sir Can we used data reconciliation with employees salary slip updation. suppose scenario is extract data from pdf (basic salary ,name,Id etc.),and compare with existing data in Excel and after that update in Excel or database.
Hi, Yes Definitely, We can use Pdf Automation or Document Understanding to extract the Data . Once all the Data is Extracted - the same can be stored in Excel / Database ... Next you can simply compare it with any destination Data source.
Hi Mukesh, 22:34 , I am using UiPath version 21.10.5.0, I too tried click activity to select sub menu using the modified selector as demonstrated by you in the video, but it is not working as the click activity in this version requires the screenshot.
@@MukeshKala Mukesh, Thanks for ur reply. I did some r&d on forum. There I came across a workaround. That is in such situations, after pressing F2 which pauses the selector indication, we have to long right click the element that we want to capture. It worked for me !
Hi Mukesh ji, I was able to understand the flow of reconci and sucessfully coded the ran sucessfully. The explanatio is too good and very much easy to nderstand. you explan very well.
Excellent , Glad to Hear that
Hi Mukesh Ji, Thnaks for explaning the excel traves is super, made the simple understand. Thanks
You are most welcome
Excellent Video sir. Complete and Concise presentation of Data table concepts, Invoke Workflow activity, For each Row, etc. Lengthy powerful content video. Very neat presentation.
Thank you so much for the Comment ! Appreciate your Feedback ..
Nice explanation and learn many more things from your videos. You are awesome!
Hey , Thank you Bro 🤓🤓 Glad it was helpful 😃
jabardast use cases he. great job !!!
Thanks a lot 😊 ... Practice Jaroor karna ..
@@MukeshKala sure! Thanks a lot
Really good video. Thank you so much!
Thank you for your comment ☺️
Nice video sir! Thank you ❤️
I got issue in 2nd use case .. but it get resolved once I used delay before counter increment.
Perfect 👍
Awesome and very useful please do more usecases
Thank you, I will
Bro in 2nd used cases for comparing and writing data first i take for each loop and iterate Source datatable after that in body i used LINQ query in if condition "(From NewDt in MasterDT where main(1).ToString.Trim.Equals (NewDt(0).toString.trim) Select NewDt).ToArray.count>0" after that store this value in one data table resultdt =(From NewDt in MasterDT where main(1).ToString.Trim.Equals (NewDt(0).toString.trim) Select NewDt).Copytodatatable after that i take assign activity and assign the value in source data table by writing source(9)=result(0)(3).tostring. Execution time of workfkow only 2 sec.
Perfect ! That should be Your approach to compare the 2 DataTable. This Video I had made keeping in mind of Beginners. Also to Match and Paste Data we can use LINQ.
If you can comment the exact LINQ and the steps you followed - Happy to PIN the Comment for the Viewers.
Hi,. Yes, if you could please mention the linq and steps , it would be helpful. Thanks
Mukesh you are champion bro
Thank you Bro :)
In the match and Update process Can we use the lookup Data table concept to bring matched country code and Rate?
Yes We Can , Another Good approach would be use the LINQ Query - That would be Faster in Execution. You Can try Exploring LINQ as well..
Hello sir,
Can you tell me in data reconciliation which type of exception may occur and how to handle them?
1. Either Source of Destination Files are Missing - Inform Business by sending Mail
2. Application required to extract Data are Not Responding or failed to Open - close Everything and Reopen Application
3.Formats of Data is different in both Data Sets - Inform the Senders about the Formats
4. No Common Field to Compare - Inform the Senders about the Formats.
5. while Sending Summary - Exception in Sending Mail - Handle outlook exceptions
Hello sir
Can we used data reconciliation with employees salary slip updation. suppose scenario is extract data from pdf (basic salary ,name,Id etc.),and compare with existing data in Excel and after that update in Excel or database.
Hi,
Yes Definitely, We can use Pdf Automation or Document Understanding to extract the Data . Once all the Data is Extracted - the same can be stored in Excel / Database ... Next you can simply compare it with any destination Data source.
@@MukeshKala thank you so much sir
@@sanujamdhade7940 Cheers 👍
Hi Mukesh, 22:34 , I am using UiPath version 21.10.5.0, I too tried click activity to select sub menu using the modified selector as demonstrated by you in the video, but it is not working as the click activity in this version requires the screenshot.
Hello , I Guess that would be not mandatory - Can you send me a screenshot of the same on my mailId - available in description.
@@MukeshKala Mukesh, Thanks for ur reply. I did some r&d on forum. There I came across a workaround. That is in such situations, after pressing F2 which pauses the selector indication, we have to long right click the element that we want to capture. It worked for me !
@@chinmayraut7693 Perfect !
can u send the link iof first video on data reconcilation
It is there in this video only bro , See the timestamps in the video description 👍