Ajay Mahendra Mishra on LinkedIn: Sequence uipath endless loop (2024)

Solution of the Day: Filter Excel Columns Using LINQ#Day1Introduction:A developer needed to filter Excel data based on two columns: Part Type and Revit System Status. Specifically, he wanted the rows that have "System Pipe Fittings", "Pipe Fittings", or "Pipe Accessories" in the Part Type column and rows that have "Completed" in the Revit System Status column.Solution Overview:When dealing with multiple conditions in LINQ queries, it's crucial to prioritize OR and AND conditions correctly by using parentheses. This ensures that the logical grouping of conditions is maintained, and the query returns the intended results. Additionally, using the "Equals" method instead of the "Contains" method can help avoid unintended matches, especially when filtering for exact matches.Solution:Initially, the developer used the "Contains" method for filtering the second column, which caused incorrect results. This was because the word "Completed" is also found in the value "In Completed". The suggested solution is to use the "Equals" method after applying the "Trim" method to ensure precise matching.Here’s how you can implement this solution using LINQ to filter a DataTable:LinQ:OutDT.AsEnumerable().Where(Function(row) (row.Field(Of String)("Part Type").Contains("System Pipe Fittings") Or row.Field(Of String)("Part Type").Contains("Pipe Fittings") Or row.Field(Of String)("Part Type").Contains("Pipe Accessories")) And (row.Field(Of String)("Revit System Status").Trim.Equals("Completed"))).CopyToDataTable()Step-by-Step Explanation:1) Input Datatable: A DataTable variable with two columns: "Part Type" and "Revit System Status", named OutDT, which has all the rows.2) LINQ Query:Part Type Condition: The query checks if the Part Type is one of "System Pipe Fittings", "Pipe Fittings", or "Pipe Accessories".Revit System Status Condition: The query ensures that the Revit System Status is exactly "Completed" by using Trim and Equals.Note: Here, in this scenario, it was confirmed that the "Completed" word will be in the same case, For case insensitivity, you could use ToLower.Equals("completed").3) Parentheses Usage: Parentheses are used around the OR conditions for Part Type to ensure they are evaluated together before applying the AND condition with Revit System Status. This ensures correct logical grouping and prioritization.4) Output: At last, ".CopyToDatatable" is used to store the filtered data as an output data table, showing only the rows that meet both conditions.Forum Topic Link: https://lnkd.in/dUJqucAaFor the input Excel data, refer to the forum topic link.Have you implemented similar solutions? Share your experiences and tips in the comments below!Happy Automation!UiPath UiPath Community#UiPath #Automation #UiPathCommunity #RPATips #SolutionOfTheDay #SolutionOfTheDay1 #AjayMishra

11

🎉 Exciting News! 🎉I am thrilled to share that I secured the 3rd place in the UiPath forum community for the month of April 2024! 🥉I want to extend my heartfelt gratitude to everyone who has supported and encouraged me along this journey. Your belief in me has truly been the driving force behind my accomplishments. Special thanks to Dheerandra Vishwakarma, and Jawagar Raja.I would also like to express my sincere appreciation to the UiPath & UiPath Community for providing such a vibrant platform for collaboration and learning. It has been an honor to be part of this incredible community.My Profile Link:https://lnkd.in/dpwumhDvForum Reward List Link:https://lnkd.in/dnWEStFyThank you once again to everyone who has been a part of this journey with me. Let's continue to strive for excellence and make a difference in the world of automation! 💼✨#UiPath #Community #Automation #AchievementUnlocked #Gratitude

28

8 Comments

Celebrating the completion of UiPath's Solution Architecture ILT! 🌟 Four days packed with invaluable insights, refining my skills in architecting top-notch automation solutions. I'm deeply grateful to my company, Feat Systems, for providing me with an opportunity to grow and excel in the field of RPA. Thanks to Himanshu Joshi from the UiPath team for being an exceptional host throughout the session. Ready and excited to drive innovation and efficiency in RPA! #UiPath #SolutionArchitecture #RPA #ILT

26

4 Comments

Thrilled to share that I've successfully wrapped up the UiPath Academy Developer Professional Training Certification! 🌟 Deeply thankful for the thorough learning journey, embracing both Classic and Modern methodologies. Major gratitude to UiPath, Mukesh Kala, Rakesh Kumar Behera & Nisarg Kadam - Makes it Happen for their enriching video content. Now, geared up for the next phase in my automation voyage! 🚀 #UiPath #RPA #Automation #uipathdeveloper #uipathacademy #developerprofessionaltraining

24

Excited to announce that I have successfully completed the UiPath Academy Developer Associate Training Certification! 🚀 Grateful for the comprehensive learning experience, covering both Classic and Modern approaches. Huge thanks to UiPath, Mukesh Kala, and Rakesh Kumar Behera for their knowledge-packed and informative videos. Ready for the next step in my automation journey! #UiPath #RPA #Automation #uipathdeveloper #uipathacademy #developerassociatetraining

35

3 Comments

Thank you Feat Systems for giving me the opportunity to embark on this Automation journey! Constantly learning, developing, and evolving are the things that keep me professionally alive and passionate.Thank you UiPath for the valuable, interesting, and well-structured courses! Looking forward to the next course ADVANCED RPA DEVELOPER Foundation!! #learninganddevelopment #rpa #automation #certification #newskills #uipath #opportunity #rpadeveloper #expediagroup #developing #learning #interesting #evolving #thankyou

32

10 Comments

I’m happy to share that I’m starting a new position as Jr. RPA Developer at Feat Systems!Looking Forward to new and exciting opportunities at Feat SystemsThank you pranali shinde, Chirag Bhayani, and Bhautik Lunagariya for seamless Onboarding!

This content isn’t available here

Access this content and more in the LinkedIn app

50

5 Comments