Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
If there is one field named as " Customer_Complaint" , which has multiple repeat values in it.
So, How I can make count of repeated "Customer_Complaint".
Example:
Header 1 | Header 2 |
---|---|
Date | Customer_Complaint |
01/01/2014 | Break |
02/01/2014 | Clutch |
03/02/2014 | Clutch |
05/02/2014 | Gear |
10/02/2014 | Clutch |
20/02/2014 | Break |
In above example Customer_Complaint with value as "Break " repeated 2 times and "Clutch" repeated 3 times.
This is just an example, but in my database there is huge number of Customer_Complaints which are repeating.
I had tried "peek function" in script, but it compares only previous row value and In my scenario each values should compare with whole values in the same field "Customer_Complaint".
How I can do this.
Kindly Help.
Try this script:
Table:
LOAD * Inline [
Date, Customer_Complaint
01/01/2014, Break
02/01/2014, Clutch
03/02/2014, Clutch
05/02/2014, Gear
10/02/2014, Clutch
20/02/2014, Break
];
Join(Table)
LOAD Customer_Complaint,
Count(Customer_Complaint) as Count
Resident Table
Group By Customer_Complaint;
Output:
Thanks Sunny T! You solved my problem! And this is a very neat solution!
Hi Sunny is that possible to count the repeated values count in expression level.