I have following requirement. I have a flat file profile (CSV) with following data (example):
I would like to count the values in the map function so the output is like this (occurrence in the first column is counted), I know I can eliminate duplicates from the first column by enforcing uniques in FF profile, but how to count first?:
I tried all the standard numeric functions and failed. Any ideas?