You may wish to identify records which share a particular set of values; this may be to clarify the signal for machine learning models, or to create a simpler user experience of searching for records with multiple AND clauses.
One way to do this is to have a column which acts as a flag highlighting the desired combination of values. This can be done easily with a transformation.
First, create an attribute in the unified dataset to represent the flag. Then, add a formula transformation, setting the output attribute to the flag attribute you just created.
A flag creating transformation could be something like this:
case when get(VAL1, 0) == 'Y' AND get(VAl2, 0) == 'Y' then array('1') else array('0') end
This transformation sets the flag to 1 when both VAL1 and VAL2 contain 'Y', or 0 otherwise.
Updated over 1 year ago