Transform using JavaScript
Infoveave Data Automation — Language Transforms
Column-level JavaScript expressions. Any derivation, any masking, any conditional logic.
Some transformation requirements are too specific for generic no-code activities — computing employee experience from a join date, masking password or account number fields before export, or applying conditional business logic with nested ternaries. Transform using JavaScript puts the full JavaScript expression language at your disposal for column-level operations, row by row, without requiring a code deployment or a dedicated script runner. Each output column is defined by a JS expression that can reference other columns in the same row.
What Transform using JavaScript does
Apply column-level JavaScript expressions to tabular data inside your Infoveave workflow. Derive new calculated columns, obfuscate sensitive values, compute date differences, and handle conditional logic — using inline JavaScript without deploying custom code.
When to use Transform using JavaScript
- You need to derive a column using logic that is specific to your business and not available in standard transformation activities
- You need to mask, obfuscate, or hash sensitive columns (passwords, account numbers, personal IDs) before delivering data to a partner
- You need to compute date-based metrics — employee tenure, days overdue, period gaps — using JavaScript date arithmetic
- Your derivation requires conditional logic (ternary expressions, nested conditions) that would be cumbersome to build in no-code tools
When to avoid it
- Your derivation is a straightforward arithmetic expression on two existing numeric columns — use a dedicated derivation activity which is simpler to audit
- You need to apply logic across multiple rows (aggregation, window functions) — use Transform using SQL for row-set operations
- You need to call an external API or service from within the transformation — JavaScript expressions run in a sandboxed context without network access
Where it fits in your Infoveave automation
Transform using JavaScript is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Transform using JavaScript
Real scenarios where this transformation saves hours of manual work.
Employee Tenure Calculation
A people analytics workflow includes employee join dates. Transform using JavaScript derives an Experience column using the expression (new Date()).getFullYear() - new Date(JoinDate).getFullYear(), producing years of service for each employee record in a single column map configuration.
Account Number Masking Before Partner Export
Before financial data is delivered to a third-party audit tool, Transform using JavaScript replaces account numbers with masked values — keeping only the last 4 digits — using a JS expression that slices the string. The Include Original option is disabled so only masked columns appear in the output.
Patient Age Derivation from DOB
Patient records include a date of birth field. The workflow derives current age using JavaScript date arithmetic, which feeds the age-band classification transformation step and the clinical analytics dashboard.
See Transform using JavaScript in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
Experience: "(new Date()).getFullYear() - new Date(JoinDate).getFullYear()"
MaskedAccount: "'****' + AccountNo.slice(-4)"
true (retain all original columns)Input Data
| EmployeeID | Name | Department | Salary | JoinDate | AccountNo |
|---|---|---|---|---|---|
| 101 | John Doe | HR | 50000 | 2020-01-15 | 9876543210 |
| 102 | Jane Smith | IT | 70000 | 2019-03-10 | 1234567890 |
| 103 | Alice Johnson | Finance | 60000 | 2021-06-25 | 5678901234 |
Output Data
| EmployeeID | Name | Department | JoinDate | AccountNo | Experience | MaskedAccount |
|---|---|---|---|---|---|---|
| 101 | John Doe | HR | 2020-01-15 | 9876543210 | 5 | ****3210 |
| 102 | Jane Smith | IT | 2019-03-10 | 1234567890 | 6 | ****7890 |
| 103 | Alice Johnson | Finance | 2021-06-25 | 5678901234 | 3 | ****1234 |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Column Map
A mapping of output column names to JavaScript expressions. Each key is the output column name and each value is a JS expression that can reference other column names from the input row. Expressions are evaluated once per row. Example: { 'YearsActive': '(new Date()).getFullYear() - new Date(StartDate).getFullYear()' }.
Include Original
If enabled, all original input columns are retained in the output table alongside the new derived columns. If disabled, only the columns defined in the Column Map are included in the output — useful for creating clean, minimal output schemas.
Frequently asked questions
Everything you need to know about Transform using JavaScript in Infoveave.
Also in Language Transforms — and what runs before & after
Transformations in the same family as Transform using JavaScript, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Transform using JavaScript is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
