Select Columns

  1. In the Available Column List section, select the check box corresponding to the columns to be included in the widget design.

 

Table_-_select_column_new.jpg

 


note.jpg Note:

You can select any number of columns. The  new_image_1.jpg sign next to a column name denotes a numeric column. The new_image_2.jpg sign denotes text. The new_image_3.jpg sign indicates a date column.

Any date column is automatically split into the Year, Month & Year, Quarter, Month, Week, Day, and Weekday sub columns. These columns are available for use in defining data sets and in designing the widget.


  1. If needed, type an alias name for the selected column in the Alias Name text box and click Apply Name.

 

Table_-_select_column_new_1.jpg

 


note.jpg Note:

The need to assign an alias name may arise because the column name defined in the database is not descriptive. An alias name is applied only within the widget where you make the change. It does not reflect in other widgets or in the database.

You can select any column name to format its text style. Selection of numeric columns allows formatting of numbers.

To format a Column:


  1. Click Next. The Define Data Set (s) page is displayed.

 


note.jpg Note:

Click Back to go to the Select Columns page. Click Cancel to exit creation of widget


 

top.jpg

<<Connection & Data Models | Define Data Set(s)>>