1

Set Value if Empty

Update the field with the given value if the corresponding cell is EMPTY
Example:
File Value :
Custom Function Value 1: Customer 1
Final File Value: Customer 1

2

Override

Update the field with the given value. It will replace the content in the file.
Example:
File Value : Jn-1
Custom Function Value 1: John
Final File Value : John

3

Replace If Matches

Replace the content with given value.
Example:
File Value : Inv-1000
Custom Function Value 1: Inv
Custom Function Value 2: INVOICE
Final File Value : INVOICE-1000

4

Skip If Matches

Skip the entire line if the given value matches with mapped field
Example:
File Value : Test
Custom Function Value 1: Test
Final File Value : Line will be skipped for import

5

Skip If Contains

Skip the entire line if mapped field contains the given value ( partial match)
Example:
File Value : Test Transaction Ignore
Custom Function Value 1: Test
Final File Value : Line will be skipped for import

6

Merge

Merge Multiple values available in the file
Example:
File Value Column 1 : John
File Value Column 2: St
Custom Function Value 1: Column 1,Column 2
Final File Value :  John St

7

Expression

Populate the file value in the given template expression ({} will be replaced by file data)
Example:
File Value : John
Custom Function Value 1: Thank You {}
Final File Value : Thank You John