Reduce csv file loading time.

[riku_okawa]

Hello, I have a question about loading files.
I am looking for a way to reduce the time it takes to load large csv data when using Alteryx.
It seems that every time I run Alteryx, it loads the file from scratch. Is it possible to load the file into Alteryx once (like intermediate table), and then the next time I run Alteryx, I don't have to load the file from scratch to reduce the loading time?
If anyone knows how to do this, please let me know.

[Qiu · Accepted solution]

@riku_okawa 
Maybe you can save the input to a .yxdb file, then read from there, it should be faster.

[messi007 · Accepted solution]

@riku_okawa,

As @Qiu said you can use .yxdb files that are really powerful when you deal with big files.

You can use as well cache and run workflow that will cache all the data, so you don't have to load it each time you run the workflow:

Hope this helps!

Regards

[riku_okawa]

Thank you for your answer. It helped me a lot!!

[riku_okawa]

Thank you very much. It helped me a lot!!

[Qiu]

@riku_okawa 
If you found our replies helpful, would appreciate you would mark them as accept. 😁