Start a new topic

Appending similar datasets

[This topic is migrated from our old forums. The original author name has been removed]

Hi I am comparatively new/novice to DbVis Is it possible to simply append two similar datasets in the pro edition ? By similar, I mean exact same structure, just diff number of rows aka data points Any help in this would be welcomed in terms of 1. If it can be done or not 2. IF it can be, then some syntax
1 Comment

[This reply is migrated from our old forums.]

Re: Appending similar datasets
Hi Manik, Assuming you mean that you have the datasets in CSV files, you can use the Import Table Data feature to import the files one after the other to the same database table. Please see the Users Guide for details: http://confluence.dbvis.com/display/UG91/Importing+Table+Data Similarly if you have SQL scripts with INSERT statements; just execute one after the other in an SQL Commander tab. If I have misunderstood your question, please don't hesitate to get back to us with more details about what you want to do. Best Regards, Hans