Labelling rows based on Grouping
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.
Answers
-
Hi Anton
You could use a Transform step and an If then else function to add a new column with that logic:
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'
)1 -
what step is that coming out of the outputs please?
0 -
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
0
