Procedure
- Drop a tRowGenerator and a tFileOutputJSON component onto the workspace from the Palette.
- Link the components using a Row > Main connection.
-
Double-click tRowGenerator to define
its Basic Settings properties in the
Component view.
-
Click [...] next to Edit Schema to display the corresponding dialog box and define
the schema.
- Click [+] to add the number of columns desired.
- Under Columns type in the column names.
- Under Type, select the data type from the list.
- Click OK to close the dialog box.
-
Click [+] next to RowGenerator Editor to open the corresponding dialog box.
- Under Functions, select pre-defined functions for the columns, if required, or select [...] to set customized function parameters in the Function parameters tab.
- Enter the number of rows to be generated in the corresponding field.
- Click OK to close the dialog box.
-
Click tFileOutputJSON to set its Basic Settings properties in the Component view.
- Click [...] to browse to where you want the output JSON file to be generated and enter the file name.
- Enter a name for the data block to be generated in the corresponding field, between double quotation marks.
- Select Built-In as the Schema type.
- Click Sync Columns to retrieve the schema from the preceding component.
-
Press F6 to run the Job.
Results
The data from the input schema is written in a JSON structured data block in the output file.