Dataset

Prepare Data

Add connection, file

• Files uploaded to Dataset cannot be deleted mannually. Files not in dataset UI will disappear automatically upon next time it opens.

Hide or Delete a Column

• In the Transform editor, you can hide or delete a column from the dataset. Doing so will creates a step in the Preparation Script Panel
• Hide vs Delete: Hidden columns are available for table joins. Hiding a column is useful when you want to use a column to create a formula but don't need the column to display in the dataset.