In this article, we will discuss best practices around the fill empty attribute task template when applied to a segmentation job. For more information on how to configure this task template, please read the Fill Empty Attribute article here.
Fill Empty and Segmentation
You may want to infer job level from job title using more than one reference table. Each output would be stored in a separate field (ex: 0P Job Levels, 0P Job Levels Data Catalog) so that it's easy to review which reference table was used to infer job level for each record.
However, you can only map one attribute to one data target field in the Export: Add/Update task template. You will need to combine both fields into one "final" field.
- Final Field - Create a "final" field in this task that will contain values from other attributes. The "final" field will contain no values by default because it was just created.
- Fill Values From - Select which fields you would like the "final" field to be filled with. The order in which you list fields is the order in which values will be filled.
- Default Value - If all fields contain no value, type up an optional default value. Leave this line empty if you wish to keep records without a final value blank.
- Copy only if target attribute is empty - When this option is checked, it will only fill the "final" field if it is empty. Our"final" field is empty by default because it was just created.
Fill Empty and Export
Use the Fill Empty Attribute task template when you want to combine outputs from multiple attributes, in order of priority, into one "final" attribute for export.
The "final" field is titled 0P Job Levels FINAL and will first contain values from the field 0P Job Levels. If this field is empty on a record, the "final" field will look to the next field, 0P Job Levels Data Catalog, to be filled.
You would then map the 0P Job Levels FINAL field to the job levels field from your target system in the Export: Add/Update task template.