contestada

You connect Tableau to an Excel file which includes a column that has mostly numeric data, but has a few date and text values mixed in. Tableau set the data type for this field as Number. What happens to the date and text values when the data is imported to Tableau

Respuesta :

Answer:

Following are the solution to this question:

Explanation:

When we link the tableau to an Excel file, it contains a column which mainly contains numerical data and also mixes some number for a date or text values. For all of this field, it table specifies the type of data as Integer. In which the data is importing into Tableau Date and text properties Its date values are determined at 1/1/1900 as well as the text value is null.

To open the link tab to import data with an excel file. Click the file then and Open it. It contains several sheets, that will all be immediately imported as classified as sheets on the leftmost column of Tableau.