Split Classifications into Separate Fields
Assume you have a classification field called site_location
with the following hierarchy:
Province > District > Commune
If you wanted to split the classifications into separate fields, you could use the following calculations:
Province:
if ($site_location && $site_location.choice_values[0]) {
SETRESULT($site_location.choice_values[0]);
}
District:
if ($site_location && $site_location.choice_values[1]) {
SETRESULT($site_location.choice_values[1]);
}
Commune:
if ($site_location && $site_location.choice_values[2]) {
SETRESULT($site_location.choice_values[2]);
}
Updated over 1 year ago