Tableau does not import all the dates in column from csv file

0 votes

I'm trying to import 'Dates' from a.csv file's 'Date column' into tableau. However, certain dates in the tableau are missing. In tableau, I don't have any filters.

Image below: Dates are grouped as 'Forecast' and 'Historical' in the Excel file. Only historical dates are displayed in Tableau, whereas forecast dates are imported as NULL. The dates column in the.csv file is all structured as a date.

Please assist me.

image

image

Apr 4 in Tableau by Vaani
• 7,020 points
57 views

1 answer to this question.

0 votes

Is it feasible to convert the csv data format to string? Or should you make the adjustment to the Tableau connection? It's simple to convert to a date in Tableau if you can obtain the "date" column into Tableau as a string.

Tableau's DATE, DATEPARSE, and MAKEDATE functions all convert non-dates to dates. (For additional information on the date conversions, see: https://tarsolutions.co.uk/blog/dates-in-tableau-the-ultimate-guide/#convert)

answered Apr 5 by Neha
• 8,560 points

Related Questions In Tableau

0 votes
1 answer

Can you please send me the file database.csv used in the Tableau training

Demo - US Crime Dataset READ MORE

answered Feb 15, 2021 in Tableau by Ibrahim
1,797 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
8,052 views
0 votes
1 answer

Not able to publish workbook in Tableau Server after upgrading it from Tableau 9.1 to 9.2

Following is a little hack that will ...READ MORE

answered Jun 19, 2018 in Tableau by xyz
• 1,560 points
477 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
62 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
73 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
52 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
82 views
0 votes
1 answer

How to fix spelling error in a field or column value using Tableau?

You should be able to use a ...READ MORE

answered Mar 10 in Tableau by Neha
• 8,560 points
73 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP