An export from a platform, like SuperOffice, to a file or database is easy to set up. This article guides you through the options of selecting the fields that end up in the exported file or database table.
Fields from the source
Once the source is set up and the type of data is selected, the Source page shows the Fields pane. That is the place where fields that need to be in the export are selected. However, in some scenarios where you need to use data from your source in a transformation, you’d also need to select those fields.
Selected fields will be added to the preview in the order in which they are shown in the Fields list.
Hide fields to exclude them from export
The fields that you needed to select from the source because they were needed in a transformation, don’t need to end up in the exported file or database table. In the Data page, right-click the column header of the field that is not required in the export and select Hide from the context menu that appears.
The column is now hidden and will not be exported.
Show hidden columns
The preview pane shows a counter of the number of hidden columns on the Show hidden columns button. Click that button to show or hide the columns that are marked as hidden.
Hidden columns, once visible, can be recognized by a light grey column name.