AnsweredAssumed Answered

Count duplicate/occurring values

Question asked by xtek on Apr 22, 2017
Latest reply on Apr 24, 2017 by asheeshkumar.sharma960440

Hi,

 

I have following requirement. I have a flat file profile (CSV) with following data (example):

 

app1,testdata
app1,testdata
app1,testdsta
app1,testdata2
app2,one
app2,two
app3,whatever
app3,field
app3,is

 

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?:

 

app1,4

app2,2

app3,3

 

I tried all the standard numeric functions and failed. Any ideas?

Thanks!

Outcomes