Answered

Westonci.ca is the best place to get answers to your questions, provided by a community of experienced and knowledgeable experts. Get quick and reliable solutions to your questions from a community of seasoned experts on our user-friendly platform. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform.

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.

Thanks for stopping by. We are committed to providing the best answers for all your questions. See you again soon. We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.