ETL and Data Integration tools - Modern ETL software for everyone

Good morning,

Do you have an example of how the mapping field "SQL Function" is used. I'm
assuming I can manipulate field level data here but I can't seem to get this
done correctly and have errors each time.

What would I enter in the SQL Function say to change "amount" to 999.99 if
the orderno > 10 else use the value from the input file.

I'm using an ODBC connection to SQL Server with your Demo file. The SQL
function before and after is working fine for me.

Thanks

Joe