Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New to QVD creation; need to "store" combined tables

I have a script which concatenates data from 5 different Loads (tbl_MAIN).  After concatenating these tables I load another table (tbl_USER) to  join to these concatenated  tables (on UserId).    In the app I can create a Straight Table Chart which shows the combined data, but I want to create an .xls or .csv in the script that can be saved/stored automatically that has all the data combined.  How do I do this?

Thanks!

5 Replies
prieper
Master II
Master II

You need to JOIN the tables and then export as .csv (STORE).

HTH Peter

Karthik3
Creator III
Creator III

At the end of script write:

STORE tbl_MAIN to tbl_MAIN.xls;

Not applicable
Author

Peter, perhaps I'm doing the Join incorrectly, but when I put JOIN between each of the loads/selects I get a much larger table that doesn't appear to be joined on the primary keys (common fields).  Suggestions?

sunny_talwar

Primary keys? Didn't you just mention that the concatenated table (tbl_Main) will be joined to tbl_USER on user ID (One field)?

I feel that Join on field should not multiply your data. Assuming tbl_Main has User ID as the foreign key and has repetition of User ID, the final table you get after joining the two table should have the same number of rows as your tbl_Main. Don't quote me on this, but this is based on my understanding and I may be totally incorrect. If you can share some information related to number of rows in tbl_Main, tbl_User and the resulting table, then that might throw some light on the issue.

Best,

S

jagan
Luminary Alumni
Luminary Alumni

Hi Dan,

Check whether they is common field names in both the tables (UserId), if this is not the case then it will become CrossJoin, or you need to need to rename the column to UserId if field name is different in one of the table.

For storing the table into CSV you can use this

STORE TableName INTO FileName.csv (txt);

Hope this helps you.

Regards,

Jagan.