Counting repeated values in a Column

Marco_13112001

Good afternoon,

Looking for a function that counts the number of times a value appears in a colunm and returns the number of that particular repetion as a number. see example below

Many thanks in adavance fo the support.

Best regards,

Marco

Mirjam Schuke

Hi Marco,

You can use the group step in a workflow and then choose for which columns you would like to count the values. A Function looks at each individual value in a column(s) independently, whereas a Workflow step looks at a column or table as a whole.

You can find more information here https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-a-workflow/#group

Marco_13112001

@Mirjam Schuke Thanks for the response.

your process will give me the total number of times that the value is repetead. However, what I need is to number the repetition itself i.e. the first repetition of A is number 1 the second receives 2 and so on for any value that is repetead in the analysed column.

Josh Boxer

Hi Marco

Thanks for clarifying your question more clearly, this has been asked previously here

https://community.experianaperture.io/discussion/837/how-to-determine-nth-occurence-in-a-column