All about Datatable - UiPath

[Divya_Bharathi]

Thanks sir

[Steven_McKeering]

Thank you @Palaniyappan!

I need to brush up my DataTable skills so this is awesome

[naveenkumarr (Naveen Kumar)]

That’s awesome bro!

[angelia (Angelia Howard)]

Thank you for this useful information all in one place!

[amithvs (Amyth)]

@Palaniyappan

Convert.ToChar(65 + dt.Columns.IndexOf("Columnname") ).ToString + (dt.Rows.IndexOf(CurrentRow)+2).ToString

Hi @Palaniyappan , Good one. I would like to get your thoughts on the below:
I have a datatable dt, with 20 rows and 5 columns.
Two of the columns are ID NUMBER and STATUS.
Column ID NUMBER and STATUS can have duplicate values. I am applying necessary filter on this and then iterating each row by row.
So out of 20 , after filtering I got 10. Bot need to process only 10.

How can I get the cell name/index of each transactions? I tried the indexof activity but it will return always as 0,1,2 etc where as I am looking for something like 5,7,9 11, etc, it will be completely random after filtering.

From the image below, bot will be applying filter on ID column for “def” and Status column “Done”. What I need result is 6 and 7 (their respective index after filtering)

Feel free to let me know if you need anything else from my side.

[mazhar.hussain]

Thanks for making my life easy.

[John.Doyle.KBX (John Doyle)]

@Palaniyappan

14. Get top N rows in a datatable

Use a assign activity like this
dt = dt.AsEnumerable().Top(5).CopyToDataTable()

I get an error in UiPath Studio 2021.10 that says “Compiler Error(s)… ‘Top’ is not a member of System.Data.EnumerableRowColection…”
should the method be Take(5) ?

[ppr (Peter Preuss)]

@John.Doyle.KBX
Yes, it is about the Take Operator

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

[felix.guan]

Hi,

I tried to use the sulotion 7. Remove duplicate records in one column

Use a assign activity like this

dt= dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)("Columnwithduplicatevalues")).Select(Function(g) g.First).CopyToDataTable

But getting error message that “GroupBy” is not a member of ‘EnumberableRowCollection(Of DataRow)’

Would you please advise how to achieve to remove duplicate row based on one column? Thanks.