How to get current date count row by row

[Raja.G (Mr.RPABot)]

Hi Team,

My expectation is below link only

How count present date count based on row by row

Hi @supermanPunch , This solution once same count appear na always pick first item , i want random anyone data Expected output: XXX = 2 YYY = 2 ZZZ = 4 AAA=3 Any one of data like XXX or YYY Please help me for this Regards, Raja G

I got least count but even count is present always pick first item that i dont want , i want if even count is there pick anyone person name randomly

[Suraj_B_Shetty (Suraj)]

Hi @Raja.G

Check this workflow.
DateCount.xaml (11.0 KB)

Hope this helps

[Suraj_B_Shetty (Suraj)]

Hi @Raja.G

Please change this in the code and check

Updated Sample Workflow
DateCount.xaml (11.0 KB)

[Raja.G (Mr.RPABot)]

Hi @Suraj_B_Shetty ,

Not worked

Came true , this data is false only expected

[Suraj_B_Shetty (Suraj)]

@Raja.G

In the file there total are 12 current date in the table . It should be true right?

[Raja.G (Mr.RPABot)]

Hi @Suraj_B_Shetty ,

XXX–2
YYY–3
ZZZ–4
AAA–1
False
XXX–2
YYY–3
ZZZ–3
AAA–1
True

[Suraj_B_Shetty (Suraj)]

Hi @Raja.G

If you are looking for row wise count then check this updated workflow.
DateCount.xaml (12.4 KB)

It give this output . Then you can check the codition based on “counter status” column.

[Raja.G (Mr.RPABot)]

Hi @Suraj_B_Shetty ,

I am not looking this , i want all row result based set condition

[Raja.G (Mr.RPABot)]

Hi @Suraj_B_Shetty ,

My Actual Expectations this only

How count present date count based on row by row

Hi @supermanPunch , This solution once same count appear na always pick first item , i want random anyone data Expected output: XXX = 2 YYY = 2 ZZZ = 4 AAA=3 Any one of data like XXX or YYY Please help me for this Regards, Raja G

[Raja.G (Mr.RPABot)]

Please look above requirement that only i want

Please anyone help me for this

[Suraj_B_Shetty (Suraj)]

Hi @Raja.G
Check this workflow. It returns the person name with least current date count
DateCount.xaml (13.0 KB)

Hope this helps

[Raja.G (Mr.RPABot)]

Hi @Suraj_B_Shetty ,

Yes worked ,
but If date count is zero of all the row na, it will give always came first person, i want anyone person randomly
and status =On

This is only my main issue

[Suraj_B_Shetty (Suraj)]

Hi @Raja.G

If date count is 0 for all row then you want check status= “On”?
In the above file if date count is 0 for all row then it should return yyy as output based on status=“On”
Please confirm

[Raja.G (Mr.RPABot)]

Yes correct but i want random so take below excel
Book1.xlsx (165.3 KB)

[Suraj_B_Shetty (Suraj)]

Hi @Raja.G
Check this workflow. It matches your requirement.
DateCount.xaml (14.9 KB)
Hope this helps.

[Raja.G (Mr.RPABot)]

Hi @Suraj_B_Shetty ,

Working fine ,thanks

[Raja.G (Mr.RPABot)]

Hi @Suraj_B_Shetty ,

Yesterday night i tested worked as per my expectation .

Today i testing , im not change anything ,again always pick first item if all 0 or any two row item same count always came 1st item

[Suraj_B_Shetty (Suraj)]

Hi @Raja.G
Random method is used to take string from array of string. But sometimes it returns the same string from array.
Use this query and check.

inputArray(new Random().Next(0,100) Mod inputArray.Length)

[Raja.G (Mr.RPABot)]

Hi @Suraj_B_Shetty ,

I checked now is working fine thanks