Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-06-18 11:41 AM

delete row

Hello,

i have a basic database qvd. can i merge this database qvd with an actual qvd with only actual changes and merge this two tables and remove the lines in the basic databse which are still existing in both tables and after that i want to concanate the lines from the actual qvd with the changes in the basic database.

I hope its clear what i need...

356 Views
0 Likes
2 Replies
richard_pearce6
Partner - Specialist
Partner - Specialist
‎2014-06-18 11:55 AM

Yes you can, If you have an ID field which is unique (and therefore duplicated) you can remove it be using:

Where not exists([ID Field])

in the load statement.

Regards

Richard

QlikCentral.com

245 Views
jaimeaguilar
Partner - Specialist II
Partner - Specialist II
‎2014-06-18 12:01 PM

Hi, search for 'Using QVDs for incremental Load' in QV help (F11), to see different scenarios,

regards

245 Views
0 Likes