Transform Using Javascript

Description

This activity transforms the data from previous activities based on a user-specified javascript snippet. The transformation allows users to filter, aggregate, and manipulate data using Javascript syntax.

Input

Data only

Output

Transformed data

Configuration Fields

Column Map Set of column names and the curresponding javascript snippet .

Include Original If enabled: Retains the original input columns with the output column else gives just the output column.

---

Sample Input

EmployeeID	Name	Department	Salary	JoinDate	SecretCode
101	John Doe	HR	50000	2020-01-15	1234abcd
102	Jane Smith	IT	70000	2019-03-10	5678efgh
103	Alice Johnson	Finance	60000	2021-06-25	9101ijkl
104	Bob Williams	Marketing	55000	2018-09-12	1213mnop
105	Emma Brown	Sales	65000	2022-02-20	1415qrst

Sample Configuration

Sample Output

EmployeeID	Name	Department	Salary	JoinDate	SecretCode	Experience
101	John Doe	HR	50000	2020-01-15	1234abcd	5
102	Jane Smith	IT	70000	2019-03-10	5678efgh	5
103	Alice Johnson	Finance	60000	2021-06-25	9101ijkl	3
104	Bob Williams	Marketing	55000	2018-09-12	1213mnop	6
105	Emma Brown	Sales	65000	2022-02-20	1415qrst	2