I have a data set like
Looks like a job for the Unpivoting node. Value Columns the Employee 1 to 5. Retained Columns: Complaint and Escalated.
Hi there @Omprakash_Jena,
after Unpivoting you can use GroupBy node two times. One to count number of complaints employee worked on and one to count number of complaint escalated per employee. For the second one you will first need to filter row where escalated? column is yes. After that use Column Appender node to have everything in one table.
Edit: Or additionally you can use Pivoting node after Unpivoting with ColumnValues as group column, escalated as pivot column and any other column with Count aggregation.
Thank you so much…!
Thank you Hans!..It’s helpful.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.