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) tojoin to these concatenatedtables (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?
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?
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.
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.