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
Bedrock Mission!

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

82 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

82 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
Affirm 1
Employee
Perrininho
Employee

Likes

0 likes

Total Posts

42 posts

Correct reply

1 solution
Top badges earned
Affirm 1
Give Back
Establish
View profile

Avatar
Affirm 1
Employee
Perrininho
Employee

Likes

0 likes

Total Posts

42 posts

Correct reply

1 solution
Top badges earned
Affirm 1
Give Back
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
Applaud 1000
Employee
Sukrity_Wadhwa
Employee

Likes

238 likes

Total Posts

1,081 posts

Correct reply

45 solutions
Top badges earned
Applaud 1000
Give back 600
Give Back 500
Give Back 400
Give back 300
View profile

Avatar
Applaud 1000
Employee
Sukrity_Wadhwa
Employee

Likes

238 likes

Total Posts

1,081 posts

Correct reply

45 solutions
Top badges earned
Applaud 1000
Give back 600
Give Back 500
Give Back 400
Give back 300
View profile
Sukrity_Wadhwa
Employee

03-02-2021

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

Status changed to: Accepted