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
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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
‎2011-06-02 04:37 AM

loading data from 2 qvd's

Hi All,

I have 2 QVD's ( week & month) which I want to consolidate in to one.

The only thing is there are records in both that have the same ID, the way it should work is to load everything from 'week' and only those from 'month' where the ID does not exist in 'week'.

I know there's an exists statement but not sure how to code it so that I achieve what I'm trying to do, if anyone can help it would be much appreciated.

Many thanks,

Phil

1,845 Views
0 Likes
1 Reply
Not applicable
‎2011-06-02 05:03 AM
Author

Sorry it was quite easy using 'where not exists(ID)' so this is working now. thanks.

187 Views
0 Likes