Input data

The input data panel shows the input tables that have been loaded into the process app as raw data. Select a table to see the fields and the data contents in the data preview. The data preview enables you to check if the input data looks as expected.

Note:

The preview shows 1000 records of data. If you want to filter for specific data, create a temporary debug query, refer to Data transformations.

Note:

The Preview panel shows the data of the last data run in which this table was recalculated. If you have made recent changes, then start a new data run to view its results, refer to Editing and testing data transformations.

Adding input tables

You can easily add input tables by uploading CSV files in the Data transformations editor. Adding an input table in the Data transformations editor does not trigger a new data run. This enables you to create the required SQL queries step-by-step when adding new input tables.

Follow these steps to add one or more input tables to the Input data.

1. Select the Add file(s) icon in the Input data section of the Data transformations editor.

2. Drag and drop one or more files that contain the data for the process app, or use the Select files option, to select the files from your computer.

3. Check the detected details for your dataset in the Encoding and Delimiter list boxes. If needed, select the appropriate settings.

4. Select Upload.

The files are uploaded and the new tables are added to the Tables list in the Input data section.

Deleting input tables

Note:

Deleting an input table removes the data for your process app. If you want to use the data in your process app at a later stage, you must re-upload the input table.

Follow these steps to delete an input table from the Input data list.

1. Locate the input table you want to delete.

2. Select the Remove table table icon.

   A confirmation message is displayed.

3. Select Delete to delete the input table.