Need to find the count from Datatable

[Dany069 (Deepak Rawat)]

Hi ,

I’m extract the data from data scrapping now i want to have count of duplicate name. Please share your view below is the example:-

ID	Name
1	AA
2	AA
3	AA
4	QQ
5	QQ
Now i need the count of AA and QQ separately.

[dkollyns (Diógenes Kollyns)]

Hello @Dany069

you can try this
Dim name as integer
For each row As DataRow In "dt_ScrappingOutput’

name = row(“Name”).tostring.count

next row

Or if you have the value in a variable of type string, try this:

dim count as integer = yourString.count

[loginerror (Maciej Kuźmicz)]

Hi @Dany069

These two should work:

yourDataTable.Select("[Name]='AA'").Count

and

yourDataTable.Select("[Name]='QQ'").Count

These queries will count the occurrences of either AA or QQ. To get the count of just the duplicates, you can subtract 1 from the query result

[Dany069 (Deepak Rawat)]

Hi,
I have used but giving error because the column name in array do i need to convert this into string row.item(columnname).

[loginerror (Maciej Kuźmicz)]

Could you post a screenshot of the exact error and of your workflow?

[Dany069 (Deepak Rawat)]

Please find the attached screenshot

[loginerror (Maciej Kuźmicz)]

Thank you. Could you add to that a screenshort of the the full syntax in your workflow?

[Dany069 (Deepak Rawat)]

[loginerror (Maciej Kuźmicz)]

This expression can be used in an Assign activity and not in a loop. For example, try this in a Log Message activity:

yourDataTable.Select("[Name]='QQ'").Count.ToString

It should print the count into the console

[balupad14 (Balamurugan)]

Hi

you can use the group by aggregation activity in the below one.

BalaReva.DataTable.Activities

Hi Friends. Below you have Documentation and Sample attachment for the “BalaReva.Datatable.Activities” You can find the Activities in DataTableExtensions NameSpace [image] Add Data Row Range It allows to add collection of datarow into DataTable. Sample File : AddDataRowRange.zip (7.8 KB) Remove Data Row Select It allows to remove the data rows based on the Select(Where) condition from DataTable. Sample File : RemoveDataRowSelect.zip (7.6 KB) Group By Aggregation(Sum,Count,Avg,Max,…

Regards
Balamurugan.S

[mchadha (Mridul Chadha)]

hi there, what will the syntax be if we are trying to get a count of a certain string rather than an exact match? for eg. in above scenario, if values are ‘AA’ or ‘QQ’, we will get the count. What if we even want the count of AA if it is part of a string (eg.‘AABB’)?
Thanks in advance

[loginerror (Maciej Kuźmicz)]

Hi @mchadha

Please see this comment

Deleting Rows from a Datatable

Hi @a2dhanja You can simply use an Assign activity like that: outputDT = inputDT.Select("Column0 not like 'Engagement'").CopyToDataTable() See attached xaml file: SelectRows.zip (8.1 KB) It selects all rows where Column0 is not Engagement. You can also add some wildcards if you need to: "Column0 not like '*Engagement*'"

[mchadha (Mridul Chadha)]

@loginerror - thank you so much for the quick response. Works fine now

[Scott_Taylor]

@loginerror

yourDataTable.Select("[Name]='AA'").Count

Trying to implement this, but the Select is not working or should I say, always returns a Count of 0 (zero)…? Any ideas as to why?

[loginerror (Maciej Kuźmicz)]

Try outputting the underlying data table to your Output panel (Output Data Table activity) or simply save it into Excel. This should give you a clue on what is going wrong there.