Count items in column

[trunghai]

Hi Everyone.

I want to count how many time items appear in column A & B as picture below.

Example : item " abc " appear total is 3 & “aaa” total is 3

Pls kindly support me with a XAML file.

Thanks in advance!Count.xlsx (8.3 KB)

[jothyprasanth.m (JothyPrasanth)]

Hi @trunghai
You can use Select method to get the count

DataTable.Select("[ColumnName] = ’ “+ValueToFilter+” ’ ").CopyToDataTable.Rows.Count.ToString

Thanks,
JothyPrasanth M

[trunghai]

Hi @jothyprasanth.m

Sorry, but I want to copy result after count to position where highlighted as below picture.

Could you pls do a XAML file ?

Thanks you!

[wija (Fredy Wijaya)]

Count.zip (17.5 KB)

^ open excel first → understand it → then run the program

[trunghai]

Hi @wija

Thanks you so much ^^

But has small issue as below picture…

[wija (Fredy Wijaya)]

oh i zip the wrong one, wait

[wija (Fredy Wijaya)]

it’s because in the filter… numer is no need “”

[wija (Fredy Wijaya)]

wait i send you the correct one.

Count.zip (17.0 KB)

why your result for 333 = 0?

[trunghai]

Hi @wija

The result still = 0 for 333 ^^

I don’t know why… Could you fix this issue ? ^^

Thanks you!

[wija (Fredy Wijaya)]

check the filter data table activity (filterCode3) → check if “code 3” = 333 → if still 0 as result, change to “code 3” = “333”

mine works fine by using “code 3” = 333

[trunghai]

Hi @wija

I have changed something but the result still same for 333

[wija (Fredy Wijaya)]

this is weird, i don’t know what is wrong because in my laptop all works fine.
my result for 333 = 4 not 0

but in your case…, if you don’t using number as code… it means my workflow helpful for you right? mark as solution if so.

[trunghai]

Hi @wija

Thanks you so much!

I will raise another topic about this issue ^^

[wija (Fredy Wijaya)]

for information.
my friend already tried my workflow too and work fine.

something weird in your excel / uipath studio. i don’t know.

[trunghai]

I have tried on another PC but the result still same

[wija (Fredy Wijaya)]

omg

[trunghai]

hi @wija

I have used another way to do this case ^^

Thank you for your way…i will study about it ^^

[wija (Fredy Wijaya)]

i see, nice!