Transform name

Name of the transform; this name has to be unique in a single pipeline.

Operation

Json block name

This value will be used as a name for json block. Can be empty string that will affect output json structure, see detailed description below.

Output value

This value will be used as a transform output field. Will contain generated json output block depending on transform settings.

Force Arrays In JSON

If checked, JSON output will be forced as a single item array.

Pritty Print JSON

If checked, JSON output will be pritty printed.

Filename

full path to output file

Append

If not checked new file will be created every time transform is running. If file with specified name already existed - it will be replaced by a new one. If checked - new json output will be appended at the end of existing file. Or if existing file is not exists - it will be created as in previous case.

Split JSON after n rows

If this number N is larger than zero, split the resulting JSON file into multiple parts of N rows.

Create Parent folder

Usually file name contains some path folder as a parent folder. If parent folder does not exists and this option is checked - parent folder will be created as a new folder. Otherwise - file not be found and transform will fail.

Do not open create at start

If not checked - file (and in some cases parent folder) will be created/opened to write during pipeline initialization. If checked - file and parent folder will be created only after transform will get any first input data.

Extension

Output file extension. Default value is ‘js’

Encoding

Output file encoding

Include date in filename?

If checked - output file name will contains File name value + current date. This may help to generate unique output files.

Include time in filename

If checked - output file name will contains file creation time. Same as for ‘Include date in filename’ option

Show filename(s) button

Add file to result filenames?

If checked - created output file path will be accessible form transform result

Fieldname

Input transform field name. Use ‘Get Fields’ button to discover available input fields

Element name

Json element name as a key. For example “A”:”B” - A is a element name, B is actual input value mapped for this Element name.

JSON Fragment

If the value is set to Y the value contained in the filed is a JSON chunk and will be treated accordingly

Remove if Blank

If the value is set to Y and value in incoming field is null the related attribute will be omitted from JSON output

Field1

Field2

Field3

A

B

1

A

B

2

B

C

1

B

C

2

B

D

4

C

5

C

F

6

C

V

6

C

B

7

Field Name

Element Name

field1

recordKey

Field Name

Element Name

JSON Fragment

Remove If Blank

field3

N

N

field3

N

N