Discover the answers to your questions at Westonci.ca, where experts share their knowledge and insights with you. Ask your questions and receive precise answers from experienced professionals across different disciplines. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals.

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

Sagot :

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.