When designing the data in query designer, the columns in the data table can be organized based on your dataset design requirements.
Refer Create Data section for better understanding with the following sections. The below image showcases the initial view of query designer.
The column names in data table can be renamed in query designer after retrieving the data from data source.
The column rename action will not affect the actual data in the data source.
Follow the below steps to rename a column in data table.
Drag and Drop tables herelike below.
To remove or avoid the unwanted columns from the query design after retrieving the data from data source, the
Exclude option can be used.
Excluding the columns from data table will not affect the actual data in the data source.
Follow the below steps to exclude and include a column in data table.
SalesOrderIDcolumn will be removed in the data preview.
You can also exclude all the columns in a single click, by clicking on the icon at the table header.
Clicking on the same icon again will include all the columns.
Minimum of one column must be in enabled state to create dataset.