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?