UiPath | Filter DataTable using LINQ Query | Handle Exception The source contains no DataRows

#rpa #uipath #linq
👉 𝐄𝐧𝐠𝐥𝐢𝐬𝐡
● This video is about filtering a DataTable using LINQ query.
● The video contains 14 different examples, how to filter a DataTable using different methods and functions.
● You will learn how to filter a DataTable using Strings, Numbers or Dates.
● You will also learn how to handle the exception: 🔴 The source contains no DataRows.

🌟 𝗖𝗼𝗱𝗲
✔ Where row("Country").ToString.Trim = "USA"
✔ Where Not row(col).ToString.IsNullOrEmpty
✔ Where CInt(row("Account").ToString) Mod 2 = 0
✔ Where CDate(row("Date").ToString) ((biggger)) CDate("05/15/2020")
✔ Where row("Name").ToString.Equals("Alexander")
✔ Where row("Name").ToString.Equals("Max")
✔ Sum(Function(x) CInt(x("Age").ToString))
✔ Average(Function(x) CDBl(x("Age").ToString))
✔ Where row("Country").ToString.Contains("USA")
✔ Not Where row("Country").ToString.Contains("USA")

🕜 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
► 00:00 Introduction
► 01:15 LINQ Query
► 04:48 1.Example - Filter DT using String.Trim
► 07:34 2.Example - Filter DT using String.Contains
► 08:07 3.Example - Filter DT using Variable
► 09:15 4.Example - Filter DT using Not
► 10:00 5.Example - Remove empty rows using one column
► 10:47 6.Example - Filter DT using multiple columns (AND)
► 12:07 7.Example - Filter DT using multiple columns (OR)
► 12:57 8.Example - Remove empty rows using all columns (Loop rows & columns)
► 18:24 9.Example - Filter DT for numbers (IsNumeric)
► 19:57 10.Example - Filter DT using number condition (row Mod 2)
► 21:10 11.Example - Filter DT using Date
► 23:25 12.Example - Filter DT and get Sum
► 26:15 13.Example - Filter DT and get Average
► 27:55 14.Example - Handle Exception The source contains no DataRows

📝 𝗟𝗜𝗡𝗤 𝗩𝗶𝗱𝗲𝗼𝘀
𝗔. 𝗣𝗔𝗥𝗧𝗜𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

𝗕. 𝗣𝗥𝗢𝗝𝗘𝗖𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

𝗖. 𝗙𝗜𝗟𝗧𝗘𝗥𝗜𝗡𝗚 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

𝗗. 𝗤𝗨𝗔𝗡𝗧𝗜𝗙𝗜𝗘𝗥 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

𝗘. 𝗘𝗟𝗘𝗠𝗘𝗡𝗧 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

✍ 𝗞𝗲𝘆 𝗪𝗼𝗿𝗱𝘀
→ UiPath
→ UiPath Automation
→ UiPath Activity
→ UiPath Linq
→ Language Integerated Query
→ LINQ in UiPath
→ Filter DataTable using LINQ query
→ Handle LINQ Exception
→ The source contains no DataRows
→ Filter DataTable for String
→ Filter DataTable for Number
→ Filter DataTable for Date
→ Filter DataTable and get sum of a column
→ Filter DataTable and get average of a column
→ Filter DataTable using one column
→ Filter DataTable using multiple columns
→ Filter DataTable using Math function
→ Clone DataTable
→ Distinct DataTable

𝗙𝗼𝗹𝗹𝗼𝘄 𝘂𝘀
🤖 𝗬𝗼𝘂𝗧𝘂𝗯𝗲: @ActAutomate
📢 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 𝗦𝗵𝗼𝗿𝘁𝘀: @ActAutomateShorts

[ActAutomate]

📝 𝗟𝗜𝗡𝗤 𝗩𝗶𝗱𝗲𝗼𝘀
𝗔. 𝗣𝗔𝗥𝗧𝗜𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

𝗕. 𝗣𝗥𝗢𝗝𝗘𝗖𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

𝗖. 𝗙𝗜𝗟𝗧𝗘𝗥𝗜𝗡𝗚 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

𝗗. 𝗤𝗨𝗔𝗡𝗧𝗜𝗙𝗜𝗘𝗥 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

𝗘. 𝗘𝗟𝗘𝗠𝗘𝗡𝗧 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦

[psrivasavi]

The BEST channel to learn LINQ use cases for UiPath. Very well explained. Thank you "UiPath - Mahmoud TV"!!

[skmNas]

You explain each topic so well like from a basic to an advance level, Please do continue the UiPath API Automation Series and also advanced topics of UiPath. Looking forward for more videos and more Knowledge gain from you. Thank you for the LINQ topics.

[ricardoguzman]

Easily on my top 3 LINQ tutorials online. Thanks a lot!

[aparnapopade]

Got detailed Understanding of Linq!!Thank You!!

[igornosenko]

You have a perfect video series about LINQ, thanks a lot. But California and Texas are not the cities :)

[wingcheunghung]

Very useful video on linq, thx a lot !

[preetikarauthan]

Hello act automate,

Really liked your videos on linq ..amazing explanation given .
Can u please create a video on how to sort any integer array asc or desc.
Thankyou!

[rasipogulabhaskar]

fantastic, superb... if you start class tell me am interested

[samtej]

If possible please teach us lamda function and more complex problem solving skills using linq like how to filter multiple columns in a single dataset and their Approaches like Array to list etc . mean while please teach us most complex real time senario based dataset manipulations.

[saiprasadkakumanu]

Hi i have following Text in a Notepad:
This is Jim

Jim is teaching VBScript

Jim will also teach UiPath

Jim will travel

i need count of word Occurances say word called "This" has occurred only once so "This -1", word called Jim occurred 4 times so "Jim -4" like that whatever text i keep i need count of each word

i tried with this - its somewhat working -
array_Tst.GroupBy(function (x) (x) x.Key, function (x) x.Count)

but i copied the syntx from google which i did not understand so checking any other wya we can do it.. pls help

[nalayathan]

Hi your way of teaching very nice.. Can you upload c# tutorials easy way.. If I become rpa developer should I learn c# right.. Atleast logic building purpose need c#.. Please if possible can you upload c#

[DrzymalaWagon]

When it comes to that no data Ross exception i prefer to assign query results to a variable of Ienumerable of datarow and then checking its content with .Any methods, if it is true i then use .copytodatatable methods on that Ienumerable variable.

[rpateam]

Hi.. Nice Video.. i want know compare the two datatable.. can expalin tolist, to array, etc... to copydatatable..in the possible way...

[abdelrahmanbadr]

19:08
"we need to use CStr method to converst the conent to string"
why ? you was already using row(Country).ToString ?! .. what is the difference between CStr and ToString and why did you use both of them ?

[samtej]

If Possible, can u suggest me the best resource for learning Linq queries from A to Z.

[balramraviks]

Hi bro, could u pls create a video on linq query updating the row value of one column with value if the another column row matches the value.
Example "column1" which contains the value "Paper" then update "Column3" = "Scissors"

[LuisFernando-uxys]

Hello Act Automate!
Today I come with a different question.
How can I get de Last row index of a specific columnn in a Data Table? I have a data table which every column is completely independent from each other. which means that a column might have info till the row 9 where another column in the same dt has info till the row 4. Let me know if you understood my question. Thank you vey much once again.

[mohanvasan]

This is good but could you explain this, on the example 8 where we look each column, If each column is looping and creating additional rows why it is not creating additional rows at the place where we have column value in the rows where we have also found empty, While empty is being ignored the other values should also create an additional row right, Could you explain that by the way tried this one after completing all your Linq videos,
(
From Row In dtInput.Rows.Cast(Of System.Data.DataRow)
Where Not Row.ItemArray.Any(Function(x)
Select Row
).CopyToDataTable

[girishkrishna]

18:11 Mahmoud, this code giving me compiling error.