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.
2. Execute the query and the data will display in preview grid as follows. 3. Double-click on the column name in the table to rename the respective column. 4. The edit mode will be enabled like below. 5. Now, modify the column name and press enter key to commit the modification done. 6. Execute the query, the renamed column will display in preview grid as follows.
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.
2. The excluded column will be represented in table design like below.
3. Now, execute the query and notice that
SalesOrderID column 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.