Skip to main content
Level 3
Feb 14, 2019 3:56 PM UTC
Accepted

Add common mappings for Boolean values

When defining the column definitions in a Load File step in a workflow, if you select Boolean for the Data Type, Campaign expects that the incoming data in the column will be either 1 or 0.

If your source data uses a different convention for Boolean values, such as Y/N (yes/no) and T/F (true/false), then you must define these in Value Remapping.  This can become cumbersome if you have many columns having the Boolean data type.  It can also lead to errors since you have to many set these for each column; you might forget to set them or set them incorrectly.

Do one of the following to alleviate this potential problem:

1. Have Campaign automatically handle input values of "Y" and "T" as "1" and values of "N" and "F" as "0".

2. When the user designates a column as Boolean, have the user select from several predefined sets of possible input values: 1/0, Y/N, T/F, etc.

3. Allow users to define a Boolean value remapping elsewhere in Campaign then reference it in the Column Properties dialog.  This would allow the user to reuse the same remapping definitions on multiple fields.

2 replies

ericperrin
Adobe Employee
Adobe Employee
Jun 10, 2019 11:50 AM UTC

This is a good idea. We will add this into our backlog and work on this as soon as we have an opportunity. For the moment, this is not prioritized.

Translate
Sukrity_Wadhwa
Level 4
Feb 3, 2021 11:18 AM UTC

This is in our backlog and would be updated here once delivered.

Translate
Sukrity Wadhwa