In the given screenshot
I want to calculate size count
The output should look like
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.
In the given screenshot
I want to calculate size count
The output should look like
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.
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
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).
Thanks!