Use the mapping formula editor to apply formulas directly in your mapping fields. Using functions in your mapping formulas, such as text and date functions, allows you to perform more complex manipulations to your data.
For example, applying the COALESCE() function when there’s a change in your file column headers. (csv[‘Media Buy Key’]) —file name is uppercase, to (csv[‘media buy key’]) —file name is lowercase. CSV fields are case-sensitive, the new header doesn’t match the name specified in the mapping, causing the new file process to fail.
After applying this formula COALESCE([csv['Media Buy Key'], csv['media buy key']]), reprocess the data stream—changes are applied allowing any failed files to go through successfully.
The formulas are intuitive and use a similar syntax as Excel. More complex manipulations can be done with MVEL, a Java-based expression language.
- VLOOKUP
Use the VLOOKUP function to retrieve specific data from a table. You can use it when you’re mapping fields from your source file to Marketing Cloud Intelligence Data Pipelines. - FUZZYVLOOKUP
The FUZZYVLOOKUP mapping formula helps identify two elements of text, strings, or entries that are similar but not identical. - REPLACE
Use the REPLACE function to replace characters or patterns in a string.