Open source softwares - Tableau

Back to Course

Lesson Description



In the wake of associating with the information source, Tableau catches the metadata subtleties of the source like the sections and their information types. This is utilized to make the aspects, gauges, and determined fields utilized in sees. You can peruse the metadata and change a portion of its properties for a few explicit necessities.

Checking Metadata

In the wake of associating with an information source, Tableau presents generally potential tables and sections present in the source. Consider the source 'Test Coffee search' for really taking a look at the metadata. Click the Data menu and decide to interface with an information source. Peruse for the MS access record named 'Test - Coffee shop'. Drag the table named Product to the information material. On picking the record, you get the accompanying screen which shows the segment names, their information types. The string information types are displayed as Abc and Numeric information types are displayed as #.

Changing Data Type

You can change the datatype of some of the fields if required. Depending on the nature of source data, sometimes Tableau may fail to recognize the data type from the source. In such scenarios, we can manually edit the data type. The following screenshot shows the option.

Renaming and Hiding

The column names can be changed by using the renaming option. You can also hide a column so that it does not appear in the data view that you create. These options are available by clicking on the data type icon in the metadata grid as shown in the following screenshot.

Column Alias

Each column of the data source can be assigned an alias which helps better understand the nature of the column. You can choose the aliases option from the above step and the following screen comes up which is used to create or edit aliases.