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
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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-01-10 03:20 AM

IL load issue

Hi All,

i think somethink wrong with my script.. when i load full load, i get  332923 lines, but when i load incremental load i get  only 6398 lines..i want load from sql only new or modified records, and concatenate wiht old qvd files by not exist id. and store in qvd.

Please help

Labels (1)
Labels
Test.qvw
368 Views
0 Likes
1 Reply
martinpohl
Partner - Master
Partner - Master
‎2014-01-10 04:01 AM

The problem is the exists statement.

QlikView will only load 1 dataset from the qvd for each offeringid. Then it exists and the second dataset is not loaded.

Maybe you can create an explicit field for example union offingid&timestamp of last change

Regards

305 Views
0 Likes