Is there a specific format for importing datasets into Tableau

+1 vote

I am working with some tabular data in R and I want it to import it into Tableau.

I know I can export the data in a variety of file formats (e.g., csv, .xlsx, .rda, etc.), but I'm wondering if there is a preferred file format from the perspective of successfully reading data into Tableau.

For example, when I export a dataset with missing values from R to a csv it codes the missing values as "NA" character strings. Tableau then misinterprets these columns as character columns. I can avoid this error by re-coding missing values in R as NULL values, but this experience got me wondering if there is a particular file format that Tableau imports most seamlessly.

Or should I export the data from R into the Tableau Data Extract (.tde) using the rtableau package?

Aug 1, 2018 in Tableau by ghost
• 1,790 points
1,099 views

1 answer to this question.

0 votes
Well I don‘t have a definitive answer for you, but as a part of work I have worked on several projects involving both R and Tableau.

I would recommend using the package to create .tde files, since this forces you to format the data in the native types provided by Tableau and should lead to the least error-prone work-flows.

Ingesting csv in Tableau has multiple possibilities of failure. Apart from those you mentioned, I once ran into the problem that Tableau chooses the column type based on the first 500 observations. Thus, depending on the data, one specific column was either identified as „numeric“ or as „integer“, leading to errors in the visualization. Similar problems exist with all non-native data types, in my experience.
answered Aug 1, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
1 answer

Is there a preferred file format for importing data into Tableau?

I don't have a final solution for ...READ MORE

answered Mar 29, 2022 in Tableau by Vaani
• 7,070 points
728 views
0 votes
1 answer

Is there a Loop function in Tableau Prep? (Problem written below)

Hey, Prep lacks a built-in looping function, ...READ MORE

answered Mar 28, 2022 in Tableau by Neha
• 9,020 points
1,217 views
0 votes
1 answer

Is it possible open a new tab for drilldown report in Tableau after publishing it

Create a replica of the Main Report ...READ MORE

answered Apr 7, 2022 in Tableau by Neha
• 9,020 points
735 views
0 votes
0 answers

Is there a possibility to generate a live reporting in tableau from jira source data?

I'm searching for a way to generate ...READ MORE

Apr 25, 2022 in Tableau by Neha
• 9,020 points
1,229 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,561 views
+2 votes
1 answer
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
3,993 views
+1 vote
1 answer

Is it possible to define a color code scheme just for one column in Tableau?

Follow the below steps : Remove your current ...READ MORE

answered Jul 24, 2018 in Tableau by Atul
• 10,240 points
2,562 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,240 points
9,832 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP