Calculate column value using JavaScript
<?xml version="1.0" encoding="UTF-8"?> <scenario> <name>Calculate column value using JavaScript</name> <script>calculate_fields</script> <driver>auto</driver> <sources> <source> <name>employee</name> <extract> <sql>select * from employee</sql> </extract> </source> </sources> <destinations> <destination> <name>employee</name> <metadata>yes</metadata> <load> <variables> <SALARY code="var value;value = fieldValue + 20000;" lang="JavaScript" /> <BONUS code="var value;value = 0;" lang="JavaScript" /> </variables> </load> </destination> </destinations> </scenario>