Data Prep

The Data Prep capability in Dataworkz lets you join two or more datasets. It supports the following operations:

• Join — Multiple join types between two or more datasets, including inner join and outer join.

• Self join — A join of a dataset with itself based on two match columns.

• Union — Combines the rows of two datasets into a single output.

• JSON modeller — Models fields of a dataset into a JSON structure.