I have 3 text files I'm trying to work with in Tableau
- A customer file... 4 million rows about 230 MB
- A call center file 1,000 rows, file size negligible
- A web activity File... 50,000 rows, but a relatively small file.
Each file contains a customerID on every row. I'm trying to look at call and web activity by different customer groups. Problem is I run out of memory every time I try to do a join between file 1 and either of the others.
I've tried extracts... loading the file to server, but can't seem to get any performance. I see other articles on forums about people breaking data into 4GB chunks... why am I having so much trouble with files under 1GB?
2 respuestas
What kind of JOIN specifically? Inner, outer, UNION, ???
What is the operating system you are using and how much RAM is in the computer? Available (free) hard drive space?
Have you closed all applications that are unnecessary?
