I'm working on a data exchange task and I'm unable to setup value mapping to a boolean field. Specifically, I would like the incoming value of "Y" mapped to Yes in the boolean field, and "NULL" to No. If value mapping is out of the question, what are some of the other recommend way of doing so?
Unfortunately, value mapping isn't an option on a boolean field as you've probably already noticed. When importing a boolean, 0 is mapped to "No", and "1" is equal to "Yes" by default, so if you have the option to change the values that are being passed in, that will work.
Otherwise, you'd probably need to look at plugging in an intermediate script that modifies the value of the field before you run the import.
Sorry, one more option just occurred to me as I was pushing the "Submit" button. You could import your values from the external system into a custom text field and then you could use a DB rule to populate your boolean field based on the value in the text field.
I would NOT really recommend this as it's sort of sloppy, and changing the source data or integration seems better. However, if you're looking for a quick 'n dirty option, it might fit the bill.