topic incremental reload with unique key in QlikView

incremental reload with unique key

Mon, 26 Jan 2026 18:19:17 GMT

Dear,

I've a problem with incremental reload for a big table with a complicate KEY from SAP

this is my script (I use the SapConnector) :

TABLE:

load

field1, field2, field3, field4, field5, field6,

field7,

field8 as date,

field1&field2&field3&field4&field5&field6 as UNIQUEKEY;

SQL SELECT * FROM TABLE where field7= 'X' or field7= 'Y', not exists(KeyCopa) ; // <---THIS IS THE PROBLEM

STORE * FROM TABLE INTO TABLE.QVD;ù

can you help me??

thanks

incremental reload with unique key

Wed, 16 Feb 2011 17:15:03 GMT

I tried also with:

SQL SELECT * FROM TABLE where (field7= 'X' or field7= 'Y') and not exists(field1&field2&field3&field4&field5&field6) ;

and also

SQL SELECT * FROM TABLE where not exists(field1&field2&field3&field4&field5&field6) ;

but don't work

incremental reload with unique key

Wed, 16 Feb 2011 17:30:04 GMT

Hi I think you are dealing with a big table in SAP which has Millions of Records and since you are not using the Key fields for reduction, it does not Work.

If you are trying try this way as in the link.. this must be helpful

http://community.qlik.com/forums/t/37787.aspx

Regards
Sravan

incremental reload with unique key

Wed, 16 Feb 2011 18:39:22 GMT

Hi,

thanks for your message

but it's impossible to have a complex syntax to where?

as this:

where field1 CA 'XY' and field2 > 1000

where (field1 = 'X' or field1 = 'Y') and field2 > 1000

kind regards

incremental reload with unique key

suniljain — Fri, 18 Feb 2011 08:11:55 GMT

Yes You can put copmlex sysntax to where but it affect extraction speed of connector.

I will suggest you to avoid complex expression during expression. And Implement copmlex expression dyring extraction From QVD it will work fast.