Back

Mapping a field that may contain blanks.

Published: Dec 08, 2011
Post Author Written by Kevin Jones

When mapping a field that may contain blanks, receiving an error that says “eConnect expected a value and none was supplied”.

You need to create a calculated field and use it in your mapping. So for instance if the column name is called TAX_CODE, and occasionally it contains a blank, your calculated field would look like this. if _TAX_CODE=”” then return string.Empty else return _TAX_CODE end if Then you map your calculated field to the appropriate destination field in your mapping.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.