tag:blogger.com,1999:blog-3174073825360154810.post8800600875955477743..comments2022-12-06T05:49:47.306-05:00Comments on QlikView Maven: Change a Table Without Reloading Report-TBhttp://www.blogger.com/profile/08386812862574514289noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3174073825360154810.post-82298397804974058522011-07-11T11:48:33.429-04:002011-07-11T11:48:33.429-04:00Thanks for this! I was struggling to figure out h...Thanks for this! I was struggling to figure out how to avoid reloading my existing table when adding a new table. I piggybacked off of this & it worked (keep existing AIR table and add new HOTEL table):<br /><br />RENAME TABLE AIR TO AIR2;<br /><br />AIR:<br />ADD NOCONCATENATE LOAD * RESIDENT AIR2;<br /><br />DROP TABLE AIR2;<br /><br /><br />HOTEL:<br />REPLACE LOAD *;<br />SQL<br />Select * from table;xine78https://www.blogger.com/profile/14895524887028125661noreply@blogger.comtag:blogger.com,1999:blog-3174073825360154810.post-63016387602067383302008-09-11T12:47:00.000-04:002008-09-11T12:47:00.000-04:00Clever idea Tim. Another technique that can be use...Clever idea Tim. Another technique that can be used to make a subset of data is the Reduce Data menu command. <BR/><BR/>Make the selections you want to filter the data and select File, Reduce Data, Keep Possible values from the menu. Then File, Save As, if you don't want to overlay your original copy.Rob Wunderlichhttps://www.blogger.com/profile/13048694338956825695noreply@blogger.com