I have absolutely no experience with R so I cannot comment on that. It doesn't look like you're using R to do anything special though, it just seems like a combination of the files. If this is correct, you could consider using the UNION feature in Tableau instead - Combine your data with Union in Tableau 9.3 | Tableau Software
Thanks for your post. That's correct yes, it's a fairly straightforward file bind. I can see in the R window that the bind is successful. The issue is then bringing that now combined file in R format to Tableau.
I tried the Union idea, and this proved to be workable but very sluggish. The speed at which R connects is much faster. I can manage to connect an R file of about 400k rows and 50 columns in about a minute. The excel equivalent took about 30 minutes.
It looks like a scale issue. I can bind multiple smaller files of the report format, but not the large ones.
Did you take a look at the link I shared? You can combine the files together directly in Tableau using the UNION approach. It can source either from Excel files or directly from CSV's in the same way your R script is.
I did yes. It's a very useful action, but unfortunately the size of the combination in this exercise makes it prohibitive.
It's essentially the same task as the R combo, but the R version compresses the data and can be processed at a much faster speed.
1 of 1 people found this helpful
OK, fair! Not entirely sure I can help on the R error. I'd suggest you create a ticket with Tableau Support in the meantime.
I did just that.
It looks like there is a complexity limit on combined files of this scale. I needed to trim down the number of columns (particularly for such columns which had some data entered as numbers, and some as text).
Once I did that it works ok.