CATEGORISE
Action
¶
Bases: BaseCategoryAction
Associate category terms in a source data field to a specific categorical term in a destination field. If there are numerous source and destination terms, then individual scripts are needed for each.
Script template
"CATEGORISE > 'destination_field'::'destination_term' < 'source_field'::['source_term']"
- If
destination_term
is a boolean (True
orFalse
) thensource_term
hits will assign that boolean value. - If
source_term
is a boolean (True
orFalse
) then any value in that column will be assignedTrue
orFalse
and convey thedestination_term
value. If thesource_term
is boolean, then there must only be one source term.
Example
"CATEGORISE > 'occupation_state_reliefs'::'other' < 'Current Relief Type'::['Sports Club (Registered CASC)', 'Mandatory']"