Iterate a set of values Macro

I have a use case where I want to calculate the count of different category values for each batch and if the count exceeds a certain limit the want to add one of the categories to the new column.

As here for each batch record id: 1-6 if count (A) >=3 then A else C.

thanks

Preparation

Accepted answers

OllieClarke

Hey @Divyang21Arora

I'm a little confused by your question, but here's a workflow that gets your desired output:

I had to change one of the As in the second group to a C based on your Count(A)>=3 logic.

However, I've a feeling this isn't exactly the process that you want. Could you give a bit more data and/or explanation?

Thanks,

Ollie

Divyang.yxmd

All comments

OllieClarke

Hey @Divyang21Arora

I'm a little confused by your question, but here's a workflow that gets your desired output:

I had to change one of the As in the second group to a C based on your Count(A)>=3 logic.

However, I've a feeling this isn't exactly the process that you want. Could you give a bit more data and/or explanation?

Thanks,

Ollie

Divyang.yxmd

DawnDuong

hi @Divyang21Arora

Not sure if i entirely understand your question, as you seem to use the word "batch" to describe group of consecutive 6 Record_ID rows, and yet there is another column called "Batch".

Also, there are 3 counts of A in each group... so i'm hazarding a guess of what the desired outcome is.

Dawn.

JustSimple.yxmd

Divyang21Arora

Thanks, @OllieClarke & @DawnDuong, both of them help me achieve the solution I was actually looking for.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703