UiPath | LINQ Training | Learn LINQ for UiPath from A to Z | LINQ Query Structure | LINQ Query Parts

[@ActAutomate]

📝 𝗟𝗜𝗡𝗤 𝗩𝗶𝗱𝗲𝗼𝘀 𝗔. 𝗣𝗔𝗥𝗧𝗜𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦 ➊ 𝗧𝗔𝗞𝗘: kzbin.info/www/bejne/hp_Eqp-BaJyagqc ➋ 𝗦𝗞𝗜𝗣: kzbin.info/www/bejne/iHW0anaoqdqggbc ➌ 𝗧𝗔𝗞𝗘𝗪𝗛𝗜𝗟𝗘: kzbin.info/www/bejne/pH6ZoIx8gbKdnLc ➍ 𝗦𝗞𝗜𝗣𝗪𝗛𝗜𝗟𝗘: kzbin.info/www/bejne/qX62fqB_fLSmq7M 𝗕. 𝗣𝗥𝗢𝗝𝗘𝗖𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦 ➊ 𝗦𝗘𝗟𝗘𝗖𝗧: kzbin.info/www/bejne/enrbYYaph7J_b9E ➋ 𝗦𝗘𝗟𝗘𝗖𝗧𝗠𝗔𝗡𝗬: kzbin.info/www/bejne/nKCceHdsp7l9iqM 𝗖. 𝗙𝗜𝗟𝗧𝗘𝗥𝗜𝗡𝗚 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦 ➊ 𝗪𝗛𝗘𝗥𝗘: kzbin.info/www/bejne/b2jFfmqZlL9mmZY 𝗗. 𝗤𝗨𝗔𝗡𝗧𝗜𝗙𝗜𝗘𝗥 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦 ➊ 𝗔𝗟𝗟: kzbin.info/www/bejne/rJCrk6SZlsqcqqs ➋ 𝗔𝗡𝗬: kzbin.info/www/bejne/q6TLfKaAdr2Fipo 𝗘. 𝗘𝗟𝗘𝗠𝗘𝗡𝗧 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦 ➊ 𝗘𝗹𝗲𝗺𝗲𝗻𝘁𝗔𝘁: kzbin.info/www/bejne/f6nTd2qiZtt2jsk ➋ 𝗘𝗹𝗲𝗺𝗲𝗻𝘁𝗔𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁: kzbin.info/www/bejne/f6nTd2qiZtt2jsk ➌ 𝗙𝗶𝗿𝘀𝘁: kzbin.info/www/bejne/gJKQapd8etFpoNU ➍ 𝗙𝗶𝗿𝘀𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁: kzbin.info/www/bejne/gJKQapd8etFpoNU ➎ 𝗟𝗮𝘀𝘁: kzbin.info/www/bejne/Y2awgmasnruhj5I ➏ 𝗟𝗮𝘀𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁: kzbin.info/www/bejne/Y2awgmasnruhj5I

[@awatafaelbadry7270]

٤١

[@ActAutomate]

?!!@@awatafaelbadry7270

[@peymanrezaee565]

Very clear! Teaching an advanced concept with simple understandable examples. Great job. Thanks a lot.

[@ActAutomate]

Thank you Peyman :-)

[@DrzymalaWagon]

These tutorials are so well made, keep going!

[@ActAutomate]

Thank you very much. Please wait for the next videos about LINQ in UiPath ;-)

[@VIJAYLNYADAV]

This video cleared many of my doubts thnx

[@ActAutomate]

Happy to hear that :-)

[@tushar8004]

Grate Video I am very clear about LINQ now

[@ActAutomate]

Very good, happy to hear that, Tishar. You can also check the other LINQ Tutorials Videos, where we explained the different operators in detail.

[@tushar8004]

@@ActAutomate Yes very well explained

[@ActAutomate]

@@tushar8004 Thanks 🥳

[@viniciuseduardo3342]

Very helpful video, congratulations for your smothly job!!

[@ActAutomate]

Thanks alot Eduardo 🤗

[@anwarsd3074]

Thank you so much for explaining in detail

[@ActAutomate]

You're welcome Anwar. You can also watch the other videos about LINQ. They are also in detail for each function etc. Just let me know your feedback also and if you need anything about LINQ, what I don't have on my channel.

[@rhiran9019]

Very clear explanation. Thanks much for the wonderful video on LINQ. Keep rocking and upload more videos on API integrations, LINQ, AI fabric, some new features of uipath RPA.. thank you so much once again

[@ActAutomate]

Thanks R Hiran. Yes I will do ;-) Just wait for the next videos -.-

[@gattuakhil2319]

very nice explanation🥰....keep doing

[@ActAutomate]

Thanks Gattu 🥰

[@StopLossTrading]

Awesome way of teaching

[@ActAutomate]

Thank you :-)

[@pravinmandadi]

Hello Mahmoud... Thank you for this wonderful video... It helped me a lot. Thanks😊

[@ActAutomate]

You're welcome Pravin 😊 You can also check the other LINQ videos, where I explained the different operators in details. There are also many different examples in each video about LINQ.

[@aparnakrishnan5465]

Very helpful video Sir😊

[@ActAutomate]

Thanks aparna :-)

[@fwziayasser4510]

Wow great video!! Thank you

[@ActAutomate]

You're welcome Fwzia ;-)

[@dheerajgupta5727]

This is the great video for beginners, I got to know about LINQ in uipath, I have a request, Please make a video on SQL in UiPath

[@ActAutomate]

Thanks for the feedback. What do you want to learn about SQL in UiPath? Please write me some examples or points, what you want to learn!

[@dheerajgupta5727]

@@ActAutomate I want to learn use of all the activities relates SQL querry and all the commands that are generally used in SQL in Uipath

[@ActAutomate]

@@dheerajgupta5727 ok I will try to do that asap ☺

[@durgamanasa1420]

nice videos sir

[@ActAutomate]

Thanks Durga 😀

[@TheOriginalbeat]

Great video Mahmoud, Subscibed.

[@ActAutomate]

Thanks @Med id lahcen

[@dineshjangra7413]

Great tutorial!!

[@ActAutomate]

Thanks Dinesh :-)

[@tonyfitzs]

wow, you guys have done a fantastic job with this, the use of TTS is a great idea, particulalrly if your not a native english speeker. I work a lot with TTS and create audio books, so I get the power of it. The only sugestion, the script still needs a little work to improve some of the flow. if you need help with this, I would be more than happy to offer my support. Anyway, I for one am a fan, the way you structure the lessons is very effective, i like the idea of the back and forth between the two charicters, but to be honest, its a little but cheesy. anyway, great work. I will be watching more of these when I get time.

[@ActAutomate]

Thanks Tony for the feedback :-) This video was the beginning. You can check the newest videos. Maybe they are better. I am happy to hear your feedback also, and how to make it better and easier to understand etc. You can contact me per mail.

[@tomasbarthalot3246]

wow this tutorial is amazing. I´m thrilled into watching the rest of the series. Thank you very much, keep it up!

[@ActAutomate]

Thanks for the feedback Thomas, very happy to hear that :-)

[@arifkilic2199]

thanks for explanation :)

[@ActAutomate]

You're welcome :-)

[@f-alzahraa_Ahmed]

did I find the best course or what, thank you is not een enough 🙏🙏🙏🙏🙏🙏🙏🙏

[@ActAutomate]

Thanks Fatima, very happy to have you here :-)

[@bartlomiejrubaj4996]

Hi, thank you very much for this great video, I have a small question, let's say I have a datatable where one column contains amount and currency, how can I use LINQ in Uipath to remove the currency from all rows in that column? Let's say there is a row 100 EUR and I want to leave only 100 and remove "EUR". If you already posted video regarding it I would appreciate the link

[@dedsec5177]

Nicely explained Mahmoud 👍, extend these linq series with more examples of DataTable/different enumerable datatype with different scenarios in future videos. Keep up the good work.✌️

[@ActAutomate]

Thank you Ded Yeah sure, I will publish new videos about LINQ for different sources, DataTables, Arrays, XML, JSON, etc. Please subscribe my channel to get the new videos ;-)

[@dedsec5177]

@@ActAutomatesure, great background music choice in whole video. 😀

[@ActAutomate]

@@dedsec5177 Thanks 😃

[@nithyaa.n7474]

Can you pls explain the how to concatinate and group the multiple row data in the uipath as soon as possible

[@ActAutomate]

Do you mean using Group By clause or method in a LINQ query ? There are many other videos about that on my channel. Please check them. If you mean something else, please give me more details and I will try to do that asap!

[@nithyaa.n7474]

Can we use Group by and concatenate at a time for same table

[@ActAutomate]

Sure. Please check the other LINQ videos to learn more about that. If you still have questions, please let me know@@nithyaa.n7474

[@nithyaa.n7474]

Hi I need one help, my uipath studio is not working means I am not able to edit anything but it will show detected attended robot asthe license type

[@girishkrishna4654]

36:38 Mahmoud, Why should we put ORDER before SELECT. You said it should be after FROM.

[@ActAutomate]

I mean after From not directly, but in general not before From. This means, you can use From, Order, Where, Select Or you can use: From, Where, Order, Select There is no difference in this case. But you can not use Order, From, .... This is the meaning of the point here.

[@tharaninatarajan2248]

Hi, This is so wonderful .Thank you for making this video so clear! can you please help me to find maximum number in the column (Dt name is Input_DT.Column name is "age")

[@ActAutomate]

I will create new videos about the other functions of LINQ, like Min, Max, Sum, etc. Please wait for the next videos. For now you need to search for Min function in LINQ. You can find it in UiPath Community. If you don't find anything, I will try to help you then, but you will find it for sure ;-)

[@tharaninatarajan2248]

@@ActAutomate Thanks ! waiting for your next video ! your explanations are so clear ..

[@ActAutomate]

@@tharaninatarajan2248 Thanks Tharani

[@nandaniraj2790]

Hi, Thank you for this wonderful LINQ series... In the last part of the video, instead of using build datatable, I have used below query but getting the "specified cast is not valid" error. Could you please suggest the solution (From row In OutputDT1 Join row1 In OutputDT2 On row("Name").ToString Equals row1("Name").ToString Select ResultDT.LoadDataRow(New Object(){row.Field(Of String)("Name"),row.Field(Of Int32)("Age")},False) ).CopyToDataTable

[@ActAutomate]

Thanks Nandani, I think you need to add this assembly in the main xaml file *System.Data.DataSetExtensions* But I would prefer to use my method in the video because it is easier to use and you don't have to write too much text. You can decide what you want to use, just suggesstion

[@ForeverUs11]

Hi Mahmoud. Very well explained thankyou. I got an error saying unexpected token when i tried to initialise XDocument.Load(strPath) to xDoc variable of type XDocument. strPath is nothing but the path of xml input file

[@ActAutomate]

Please first check the following videos about XML. I think you will find the answer you need there. If you still need help, please let me know. XML For Beginners: kzbin.info/www/bejne/qmeni6aOhtGXsKs XML in UiPath: kzbin.info/www/bejne/m2ini3uIZ8x2gac LINQ XML: kzbin.info/www/bejne/hpfZkoF9eLxpfs0 Last(OrDefault): kzbin.info/www/bejne/Y2awgmasnruhj5I

[@devashishnigam5971]

Great video! Is there any way to select all columns then writing them one by one in out.Rows. Add ( ..... )

[@ActAutomate]

Thanks Devashish :-) I don't know what you mean exactly. What do you want to do? If you want to loop through rows and columns in LINQ query, you can watch this video to learn that. Maybe it could help you. kzbin.info/www/bejne/fnfEnmCDrpuHas0 Else please explain more about your question and I will try to help you further ;-)

[@devashishnigam5971]

@@ActAutomate Out_DT.Rows.Add( specifying column names).....rather than manually selecting columns can we select all columns in inner join b/2 DataTables

[@ActAutomate]

@@devashishnigam5971 Ah ok now I understand your question. It's not easy to implement. I will create a new video how to do this. Just wait please!

[@polugopi8194]

i have a question, here you are using one data table and getting unique value @30:00 and what about the same task by utilizing 2 data tables?

[@ActAutomate]

Certainly! It sounds like you're working with data tables and aiming to extract unique values from them. Whether you're using tools like **Power BI**, **Excel**, **SQL**, or programming languages like **Python (pandas)**, the general approach can vary slightly based on the platform. I'll provide a broad overview for handling this task using **two data tables** compared to using a **single data table**. ### **Scenario with a Single Data Table** When you have one data table and want to extract unique values, the process typically involves: 1. **Identifying the Column(s):** Determine which column(s) you want to retrieve unique values from. 2. **Applying a Distinct Operation:** - **Power BI (DAX):** Use the `DISTINCT` function. - **Power Query:** Use the "Remove Duplicates" feature. - **SQL:** Use `SELECT DISTINCT`. - **Python (pandas):** Use `df['column'].unique()` or `df['column'].drop_duplicates()`. *Example in Power BI DAX:* ```DAX UniqueValues = DISTINCT(Table1[ColumnName]) ``` ### **Scenario with Two Data Tables** When working with **two data tables**, you might want to extract unique values across both tables or based on some relationship between them. Here's how you can approach it: #### **1. **Appending/Combining the Tables** If both tables have the same structure and you want a combined list of unique values: - **Power BI (Power Query):** - **Append Queries:** Go to **Home > Append Queries** to stack the tables. - **Remove Duplicates:** After appending, select the column and choose "Remove Duplicates". - **SQL:** ```sql SELECT ColumnName FROM Table1 UNION SELECT ColumnName FROM Table2; ``` The `UNION` operation automatically removes duplicates. - **Python (pandas):** ```python combined = pd.concat([df1['ColumnName'], df2['ColumnName']]).unique() ``` #### **2. **Merging/Joining the Tables** If the tables are related and you want unique values based on a relationship: - **Power BI (DAX):** - **Relationships:** Ensure there's a relationship defined between the two tables. - **Using `UNION` in DAX:** ```DAX CombinedUnique = DISTINCT( UNION( SELECTCOLUMNS(Table1, "ColumnName", Table1[ColumnName]), SELECTCOLUMNS(Table2, "ColumnName", Table2[ColumnName]) ) ) ``` - **SQL:** ```sql SELECT DISTINCT T1.ColumnName FROM Table1 T1 JOIN Table2 T2 ON T1.Key = T2.Key ``` Adjust the `JOIN` type (INNER, LEFT, etc.) based on your specific requirements. - **Python (pandas):** ```python merged = pd.merge(df1, df2, on='KeyColumn') unique_values = merged['ColumnName'].unique() ``` #### **3. **Using Lookup Tables or Relationships** If you're referencing unique values from one table in another: - **Power BI:** - **Create a Relationship:** Define relationships in the model view. - **Use LOOKUPVALUE or RELATED:** To fetch unique values based on relationships. - **SQL:** Utilize foreign keys and join operations to fetch related unique values. ### **Practical Example in Power BI** Let's assume you have two tables: - **Sales 2022** - **Sales 2023** **Objective:** Get a unique list of Product IDs sold across both years. **Steps:** 1. **Append Queries:** - Go to **Home > Append Queries** in Power Query. - Select both **Sales 2022** and **Sales 2023**. 2. **Remove Duplicates:** - Select the **ProductID** column. - Click on **Remove Duplicates** in the ribbon. 3. **Load the Data:** - This will give you a single table with unique Product IDs from both years. **Alternative DAX Approach:** ```DAX UniqueProductIDs = DISTINCT( UNION( SELECTCOLUMNS('Sales 2022', "ProductID", 'Sales 2022'[ProductID]), SELECTCOLUMNS('Sales 2023', "ProductID", 'Sales 2023'[ProductID]) ) ) ``` This DAX formula creates a new table `UniqueProductIDs` containing distinct Product IDs from both sales tables. ### **Key Considerations** - **Data Consistency:** Ensure that the columns you’re combining have the same data types and formats to avoid errors. - **Performance:** For large datasets, operations like `UNION` and `JOIN` can be resource-intensive. Optimize your queries or consider indexing if using databases. - **Relationships:** Clearly define how your tables relate to each other to accurately extract and combine unique values. - **Tool-Specific Functions:** Each platform has its own set of functions and best practices. Familiarize yourself with the ones relevant to your tool (e.g., Power Query M functions vs. DAX functions in Power BI). ### **Conclusion** Extracting unique values from two data tables involves deciding whether to **combine** them first (through appending or merging) and then extracting unique values, or to extract unique values separately and then combine those results. The exact method depends on your specific requirements and the tools you're using. If you provide more details about your data setup or the tool you're using, I can offer a more tailored solution!

[@aditya10989]

Thanks for wonderful video shall you please provide us query using inbuilt function like sum()

[@aditya10989]

Oh sorry got it in next video 😜

[@ActAutomate]

Very good. But the other functions are on the checklist, like sum function. Just wait for the next videos ;-)

[@aditya10989]

Sure please upload some more video on orchestrator multi bot architecture regex

[@ActAutomate]

@@aditya10989 Can you please give me more details? What do you mean with 'orchestrator multi bot architecture regex'?

[@aditya10989]

@@ActAutomate sure like regular expressions , re framework queues ,uipath test suite,test manager advance topic in uipath

[@abdelrahmanbadr2404]

What is the prerequisites for this course? Should i finish uipath foundation course before starting this one ?

[@ActAutomate]

Hi Abdelrahman, Yes you need it, so that you can know the different activities and the different data types, and also the basics of UiPath. This course is more for advanced developers, who want to increase the performance of the code using LINQ queries instead of Loops etc. But it will be good for you to learn it from beginning, so that you can use it in your projects. If you have any questions or needs, just write us and we will try to help you further ;-)

[@ActAutomate]

And we also have other videos about LINQ in the channel. Please check the LINQ playlist to see the different functions in LINQ. We will also publish new videos about LINQ in the next time

[@abdelrahmanbadr2404]

@@ActAutomate thank you :)

[@ActAutomate]

@@abdelrahmanbadr2404 You're welcome Abdelrahman :)

[@ruchi646]

Hi, How can I get all the output numbers 2,4,6,8 in one single message box? in case of the LINQ array modulo example

[@ActAutomate]

In this case is the output an Array. You have to convert the Array to String. To do this, you can use the following statement after the LINQ query: String.Join(";" , Output_Numbers) In this case, you will get the following text: 2;4;6;8 But you can use another Separator, for example: String.Join("." , Output_Numbers) The output will be: 2.4.6.8

[@ruchi646]

@@ActAutomate Thank you so much for this! Also, can I get to enter space instead of the "," or "." ? Thanks!

[@ruchi646]

So that my output is: 2 4 6 8

[@ActAutomate]

Yes of course. You only have to set the following: String.Join(" " , Output_Numbers)

[@girishkrishna4654]

Mahmoud, Why suggestions were not coming up when using .ToArray, .CopyToDataTable?

[@ActAutomate]

In case of Query Syntax, we don't get the suggestions. But if you are using Method syntax, you will get the suggestions. This is in general. But to get the suggestions for arrays for example, you have to use it in this way: MyArray.AsEnumerable To learn more about the Query and Method syntaxes, please check the video on my channel, where I explained both. The video is called: Write LINQ Query

[@hantrantruongngoc3528]

in which case we use datatable.asenumerable()??

[@ActAutomate]

There is another video, where I explained the 3 different ways of writing a LINQ query. Please check it on my channel. These are: 1. Query Syntax 2. Method Syntax 3. Mixed Syntax In case you are writing a LINQ query using Method syntax and you want to query a DataTable, you *MUST* use DataTable.AsEnumerable, else you can not write the query (query is wrong) But in case you are writing the query using Query or Mixed syntax, you *CAN* use the AsEnumerable method, but you don't have to. My recommendation is to use it in all 3 different ways. Why? Because once you are using the method, you have suggestions from UiPath once you want to write a method etc. I mean for example the following query: ( From row in MyTable.AsEnumerable Where row("Name").ToString.StartsWith("X") Select row ).CopyToDataTable() Here I used the variable row (as range variable) to loop the data source (MyTable). I used the method AsEnumerable, therefore once I want to use row inside the query, UiPath knows that the variable row is of type DataRow and gives me suggestions for this type, such as the properties ItemArray, Item, etc. Without using this method, UiPath doesn't know what is this variable and gives no suggestions. In this way you must know the methods and properties of DataRow, so that you can use them, because no suggestions will be shown. Here are examples about the three different LINQ Syntaxes: *Query Syntax:* From row in MyTable.AsEnumerable Where row("Name").ToString.StartsWith("X") Select row *Method Syntax:* MyTable.AsEnumerable.Where(Function(row) row("Name").ToString.StartsWith("X")).CopyToDataTable *Mixes Syntax:* ( From row in MyTable.AsEnumerable Where row("Name").ToString.StartsWith("X") Select row ).CopyToDataTable() If you still have any questions, please let me know. Happy coding :-)

[@hantrantruongngoc3528]

@@ActAutomate thanks for clarifying. Much appreciated

[@ActAutomate]

@@hantrantruongngoc3528 Any time 🙂

[@aakashjogalekar2661]

how to select all columns (of both tables) after joining two tables is there any code like in SQL we can say (Select * from )

[@ActAutomate]

Unfortunately we don't have a solution for that. We are working on it, so that you don't need to select each column. For now we have to select each column we need. We will post a new video about that, once we find a solution!

[@aakashjogalekar2661]

@@ActAutomate ok thank you

[@yashobantadash6670]

cant we do without building data table in last part of video?

[@ActAutomate]

Sure! You can add the following instead of: out_DT.Rows.Add .... You can add this: Select dtResult.LoadDataRow(New Object(){tb1.Field(Of String)(“City”)},False)).CopyToDataTable In this example you create a new column "City" from type string. If you have an error, you need to check the imports.

[@andy_gamez2826]

Hi!! Can i request xaml file for practice?

[@ActAutomate]

Hi Andy, Do you mean the xaml files from this video? Unfortunately I don't have them anymore. If you need something specific, just let me know and I will try to send you something about it. You can also check the other videos, where I also have many other queries and functions.

[@sunnysingh-ng5bz]

Hi Mahmoud while performing Linq quey on datable i get any error "Assign: The source contains no DataRows." . source is excel sheet and read data and get datatable . pls help

[@ActAutomate]

Hi Sunny, Can you please share your query? And also the data in your Excel sheet? This issue appears, if the output of your query doesn't have any rows (no output matches), therefore you get this problem. To solve the problem you need if condition. In this condition you have to set the following: If the output is nut empty, then get the output as it is, else get an empty datatable. How to do that exactly and how to use the IF condition in LINQ query? --> This is my next video in the next days. I am working on it currently.

[@sunnysingh-ng5bz]

@@ActAutomate yes Mahmoud i will share it soon and eagerly waiting for next video .. thank you so much .. your content is very helpful . i m following your channel on linkdn and on youtube .. if possible can i get ur email id pls ..

[@ActAutomate]

@@sunnysingh-ng5bz Just write me in LinkedIn and I will try to help you, if I can ;-)

[@sunnysingh-ng5bz]

@@ActAutomate sure thank you mahmoud :)

[@ActAutomate]

@@sunnysingh-ng5bz ☺

[@dheerajgupta5727]

What's wrong in this Statement

[@ActAutomate]

Which statement exactly? You didn't add it here!

[@retalwmakah]

قؤ

[@ActAutomate]

:-D

[@toanhm2]

dt.AsEnumerable().ToList().ForEach(Sub(row) row.SetField("ngày", Convert.ToDouble(row.Field(Of Integer)("time")) * 24)) dt.Columns("ngày").SetOrdinal(dt.Columns.Count - 1) dt.AsEnumerable().ToList().ForEach(Sub(row) row.SetField("Tên cột", If(String.IsNullOrEmpty(row.Field(Of String)("Tên cột")), "", Convert.ToDouble(row.Field(Of String)("Tên cột")).ToString("N2")))) dt.AsEnumerable().ToList().ForEach(Sub(row) row.SetField("ngày", Convert.ToDouble(row.Field(Of Integer)("time")) * 24))

[@ActAutomate]

Do you need help or what exactly? You only wrote the code lines without any comments. I don't know what do you need. Please let me know.