Modified JavaScript Value

Workshop - Modified JavaScript value

The Modified Java Script Expression step in Pentaho Data Integration (PDI) allows users to execute custom JavaScript code to transform and manipulate data within a transformation. This step provides a powerful scripting environment where you can write JavaScript functions to perform complex calculations, data validations, string manipulations, and conditional logic that might be difficult or impossible to achieve with standard PDI steps.

The step takes input fields from the data stream, processes them through your custom JavaScript code, and outputs the results as new fields or modified existing fields. It's particularly useful for implementing business rules, data cleansing operations, or complex transformations that require programming logic beyond what built-in PDI steps can provide.

Modified JavaScript Value

---

First Tab

Second Tab

1. Generate rows

Generate rows

The Generate Rows step in Pentaho Data Integration (PDI) is a data generation component that creates synthetic data rows based on user-defined specifications. This step allows you to generate test data, sample datasets, or placeholder records by defining field names, data types, and value ranges or patterns.

You can specify how many rows to generate and configure various parameters like random number ranges, date intervals, or fixed values for each field. It's particularly useful for testing transformations, creating mock data for development purposes, or generating large datasets for performance testing without requiring an external data source.

Generate rows

2. Modified JavaScript Value