Search results
PDF

Formatting Columns

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.Query Designer initial state

Rename a column

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.

  1. Drag a table or view from the left pane and drop it into the center pane labeled with Drag and Drop tables here like below. Drag and drop table into design area
  2. Execute the query and the data will display in preview grid as follows. Data preview before rename action
  3. Double-click on the column name in the table to rename the respective column. Enable the column edit mode
  4. The edit mode will be enabled like below. Column name edit mode
  5. Now, modify the column name and press enter key to commit the modification done. Modify the column name
  6. Execute the query, the renamed column will display in preview grid as follows. Data preview after rename action

Exclude columns

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.

  1. Exclude the column that you requisite, by clicking the icon at left corner of the respective column name. Exclude icon
  2. The excluded column will be represented in table design like below. Exclude action representation
  3. Now, execute the query and notice that SalesOrderID column will be removed in the data preview. Data preview after column exclude action

You can also exclude all the columns in a single click, by clicking on the icon at the table header.

Exclude all columns

Clicking on the same icon again will include all the columns.

Include all columns

Minimum of one column must be in enabled state to create dataset.