Add column to the destination on the fly using JavaScript
<?xml version="1.0" encoding="UTF-8"?> <scenario> <name>Add column on the fly and set value using JavaScript</name> <script>add_field_js</script> <driver>com.toolsverse.etl.driver.GenericFileDriver</driver> <sources> <source> <name>some_excel_spreadheet</name> </source> </sources> <destinations> <destination> <name>another_excel_spreadheet</name> <source>some_excel_spreadheet</source> <load> <variables> <SOME_FIELD /> <TEST add="true" code="var value; value = {SOME_FIELD} + ' ' + 'test';" lang="JavaScript" /> </variables> </load> </destination> </destinations> </scenario>