Labelling rows based on Grouping

AntonBurridge

Is there an easy way of labelling rows based on a grouping step?

in my source data of roughly 25,000 rows, I have 2 validation columns; valid email and valid mobile number, populated with true and false. When grouped they form 4 categories; FALSE FALSE, FALSE TRUE, TRUE FALSE, AND TRUE TRUE.

What i want to do is mark each row based on their vaildations, for example FALSE FALSE to be labelled "Neither", TRUE FALSE to be labelled "Phone only" etc etc. So that i can separate the data into 4 sections at a later stage.

Is there an easier way of doing this from the groupings, or am i best putting a transform step in after? I'm quite new to Aperture but picking up bits as i go along.

Josh Boxer

Hi Anton

You could use a Transform step and an If then else function to add a new column with that logic:

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-functions/#logical-operators~native-functions

var Phone = Equals([c:Telephone], 'Pass');

var Email = Equals([c:Email], 'Pass');

IfThenElse(

And([v:Phone], [v:Email]),

'Both',

[v:Phone],

'Phone only',

[v:Email],

'Email only',

'Neither'

)

AntonBurridge

what step is that coming out of the outputs please?

Josh Boxer

Not sure I understand your latest question, do you meant the Variables ?

They are a way to re-use the same values and so simplify a Function