I am culling several .csv files and also hitting a database to create a very large table that my departments wants exported into .csv so they can use it in another BI tool. The file has gotten so big I can no longer export it via right click > export or by hitting the export to XL button. I've seen a few examples of statements for the load script to export the data, such as
Store TABLENAME into TABLENAME.txt --
only I am not sure what the table name would be as I'm pulling from several sources and allowing similar field names to link. Do I declare the final result as a table somewhere, then use that statement? What is the preferred method for a final product of some 200 cols and 80K records to be exported to .csv?
As I understand it, the Store command only stores one table at a time. If I am understanding your requirement correctly, then I think you would have to either store each table separately (using the store command you mention (storing as csv, txt etc) and let the other BI tool to do the joins Qlikview is doing) or do the joins in Qlikview to create one large table before storing.
If the tables associate with similar field names you should be able to do joins using left join/outer join etc depending on the tables.
I found the below page useful when wanting to understand joining options . Hope that helps
