Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Add common mappings for Boolean values

Avatar

Avatar
Shape 1
Level 4
eeidbgsu
Level 4

Likes

81 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Shape 10
Boost 50
Boost 5
Boost 3
View profile

Avatar
Shape 1
Level 4
eeidbgsu
Level 4

Likes

81 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Shape 10
Boost 50
Boost 5
Boost 3
View profile
eeidbgsu
Level 4

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
Establish
Employee
Perrininho
Employee

Likes

0 likes

Total Posts

42 posts

Correct Reply

0 solutions
Top badges earned
Establish
View profile

Avatar
Establish
Employee
Perrininho
Employee

Likes

0 likes

Total Posts

42 posts

Correct Reply

0 solutions
Top badges earned
Establish
View profile
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
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

154 likes

Total Posts

910 posts

Correct Reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

154 likes

Total Posts

910 posts

Correct Reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

03-02-2021

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

Status changed to: Accepted