UiPath | LINQ Group Function | Get Unique Rows from DataTable | Duplicate Rows | Not Duplicate Rows

Опубликовано: 04 Октябрь 2024
на канале: Act Automate

11,303

137

#rpa #uipath #linq
👉 𝐄𝐧𝐠𝐥𝐢𝐬𝐡
● This video is about explaining the group function in LINQ queries.
● The following points are addressed:
→ What does the group function look like in LINQ?
→ How does the LINQ query look in LINQ with a group function?
→ Output the unique rows from a data table using one or more columns
→ Output the duplicate rows from a data table using one or more columns
→ Output the non-duplicate rows from a data table using one or more columns

LINQ Training Video:
   • UiPath | LINQ Training | Learn LINQ f...

👉 𝐆𝐞𝐫𝐦𝐚𝐧
● In diesem Video geht es darum, die Group Funktion in LINQ Abfragen zu erklären.
● Es werden folgende Punkte angegangen:
→ Wie sieht die Group Funktion in LINQ aus?
→ Wie sieht die LINQ Abfrage in LINQ mit einer Group Funktion?
→ Die eindeutigen Zeilen aus einer Datentabelle anhand einer oder mehreren Spalten ausgeben
→ Die doppelten Zeilen aus einer Datentabelle anhand einer oder mehreren Spalten ausgeben
→ Die nicht doppelten Zeilen aus einer Datentabelle anhand einer oder mehreren Spalten ausgeben

🌟 𝗖𝗼𝗱𝗲
✔ Group row By a = row("ColumnName").ToString.Trim Into grp = Group

🕜 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
► 0:00 Introduction
► 0:25 LINQ Query - Group Function
► 2:00 1.Example: Get Unique Rows
► 8:30 2.Example: Get Not Duplicate Rows
► 14:10 3.Example: Get Duplicate Rows
► 18:52 Conclusion

📝 𝗟𝗜𝗡𝗤 𝗩𝗶𝗱𝗲𝗼𝘀
𝗔. 𝗣𝗔𝗥𝗧𝗜𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗧𝗔𝗞𝗘:    • UiPath | TAKE Function - LINQ | LINQ ...
➋ 𝗦𝗞𝗜𝗣:    • UiPath | SKIP Function - LINQ | LINQ ...
➌ 𝗧𝗔𝗞𝗘𝗪𝗛𝗜𝗟𝗘:    • UiPath | TAKEWHILE Function - LINQ | ...
➍ 𝗦𝗞𝗜𝗣𝗪𝗛𝗜𝗟𝗘:    • UiPath | SKIPWHILE Function - LINQ | ...

𝗕. 𝗣𝗥𝗢𝗝𝗘𝗖𝗧𝗜𝗢𝗡 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗦𝗘𝗟𝗘𝗖𝗧:    • UiPath | SELECT Function - LINQ | LIN...
➋ 𝗦𝗘𝗟𝗘𝗖𝗧𝗠𝗔𝗡𝗬:    • UiPath | SELECTMANY Function - LINQ |...

𝗖. 𝗙𝗜𝗟𝗧𝗘𝗥𝗜𝗡𝗚 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗪𝗛𝗘𝗥𝗘:    • UiPath | WHERE Function - LINQ | LINQ...

𝗗. 𝗤𝗨𝗔𝗡𝗧𝗜𝗙𝗜𝗘𝗥 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗔𝗟𝗟:    • UiPath | ALL Function - LINQ | LINQ T...
➋ 𝗔𝗡𝗬:    • UiPath | ANY Function - LINQ | LINQ T...

𝗘. 𝗘𝗟𝗘𝗠𝗘𝗡𝗧 𝗢𝗣𝗘𝗥𝗔𝗧𝗢𝗥𝗦
➊ 𝗘𝗹𝗲𝗺𝗲𝗻𝘁𝗔𝘁:    • UiPath | ElementAt Operator | Element...
➋ 𝗘𝗹𝗲𝗺𝗲𝗻𝘁𝗔𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁:    • UiPath | ElementAt Operator | Element...
➌ 𝗙𝗶𝗿𝘀𝘁:    • UiPath | First Operator | FirstOrDefa...
➍ 𝗙𝗶𝗿𝘀𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁:    • UiPath | First Operator | FirstOrDefa...
➎ 𝗟𝗮𝘀𝘁:    • UiPath | Last Operator | LastOrDefaul...
➏ 𝗟𝗮𝘀𝘁𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁:    • UiPath | Last Operator | LastOrDefaul...
➐ 𝗦𝗶𝗻𝗴𝗹𝗲:    • UiPath | Single Operator | SingleOrDe...
➑ 𝗦𝗶𝗻𝗴𝗹𝗲𝗢𝗿𝗗𝗲𝗳𝗮𝘂𝗹𝘁:    • UiPath | Single Operator | SingleOrDe...
➒ 𝗗𝗲𝗳𝗮𝘂𝗹𝘁𝗜𝗳𝗘𝗺𝗽𝘁𝘆:    • UiPath | DefaultIfEmpty Operator | LI...

📝 𝐏𝐫𝐨𝐜𝐞𝐝𝐮𝐫𝐞
➊ How does the LINQ query look with Group function
➋ First Example: Get Unique Rows from DataTable using one column
➌ First Example: Get Unique Rows from DataTable using two columns
➍ First Example: Get Unique Rows from DataTable using three columns
➎ Second Example: Get Not Duplicate Rows from DataTable using one column
➏ Second Example: Get Not Duplicate Rows from DataTable using two columns
➐ Second Example: Get Not Duplicate Rows from DataTable using three columns
➑ Third Example: Get Duplicate Rows from DataTable using one column
➒ Third Example: Get Duplicate Rows from DataTable using two columns

✍ 𝗞𝗲𝘆 𝗪𝗼𝗿𝗱𝘀
→ UiPath
→ UiPath Automation
→ UiPath Activity
→ LINQ Query
→ LINQ Abfrage
→ LINQ Group Function
→ Get Unique Rows from DataTable with LINQ Query
→ Get Duplicate Rows from DataTable with LINQ Query
→ Get Not Duplicate Rows from DataTable with LINQ Query

🔔    / @actautomate