Answered

Welcome to Westonci.ca, the Q&A platform where your questions are met with detailed answers from experienced experts. Get detailed and accurate answers to your questions from a community of experts on our comprehensive Q&A platform. Experience the convenience of finding accurate answers to your questions from knowledgeable experts on our 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.

Thank you for visiting. Our goal is to provide the most accurate answers for all your informational needs. Come back soon. We appreciate your visit. Our platform is always here to offer accurate and reliable answers. Return anytime. Westonci.ca is committed to providing accurate answers. Come back soon for more trustworthy information.