Sometimes, when importing, the incoming data isn't set-up exactly as you need it to be. On nearly every field settings within Importacular, you have the option to apply a 'Data Transformation'. This sounds more complex than it actually is. At it's core all you are telling Importacular to do, when you apply a Data Transformation, is to take the incoming value and changes it (transforms it) into a different value.
In fact, we encourage you to apply any necessary transformation in the template rather than making any manual changes to the data source, greatly reducing the amount of human-error that can occur.
Importacular offers you a variety of different matching options as well as a variety of different types of replacement options. Most recently, we added a 'Replace Type' that allows you change the incoming value to a different 'field' from within your data source.
For example, your data source is more flexible than you would like it to be and it allows users to populate an Address either by populating a few address lines or by populating a few address line and a City field. The result is some times the City field is blank and sometimes it is populated. In the instances, when the City field is blank, Address Line 2 or 3 contains the City instead.
To ensure that City is always populated in your RE, apply a Data Transformation that looks for a Blank value in the Data Source, set the Replace Type to 'Field' and then select the relevant field from your data source in the 'Change to Target' dropdown (in this case, address line 2):
For more information about Data Transformations, please take a look at the relevant section with the User Guide: https://www.zeidman.info/docs/importacular-user-guide-3/data-transformations/
***DID YOU KNOW? Series***
We are creating a series of useful hints and tips called 'Did You Know?'. If you type in 'Did You' into the Knowledge Base search bar, they will all appear. This list will grow over the coming months, so do check back in for any new ones.