Count the number of values present

In the given screenshot image

I want to calculate size count

The output should look like image

Here for each quality(groupby shown with colour) then for each design in (groupby) count the number of duplicate size and assign into size count.

tableCompare.xlsx (8.7 KB) CountCalculation.xaml (8.4 KB)

Try this @Soniya215


Thanks @kadiravan_kalidoss i used the workflow in my actual data but it is showing the error Assign: Syntax error: Missing operand after ‘2’ operator.


can u share your xaml and sample input file.!


Here is my sample actual data and xaml file Sample.xlsx (8.3 KB) CountCalculation.xaml (8.4 KB)

CountCalculation.xaml (8.4 KB)

Check this updated.! @Soniya215

Thanks @kadiravan_kalidoss it worked sucessfully on my actual data.
what should i do if i want to add the size count of duplicate rows in the “Duplicate” column.

Thanks again

Hi @Soniya215,

Change the column index accordingly, if duplicate column falls on 5th column change the following assign statement like row(4).

column index