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!

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.

Thanks

can u share your xaml and sample input file.!

@Soniya215

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

Thanks!