Add common mappings for Boolean values

Avatar

Avatar

eeidbgsu

Avatar

eeidbgsu

eeidbgsu

14-02-2019

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 Comments

Avatar

Avatar

Perrininho

Employee

Avatar

Perrininho

Employee

Perrininho
Employee

10-06-2019

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.

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

03-02-2021

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

Status changed to: Accepted