Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

incremental reload with unique key

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

4 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

or

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

kind regards

suniljain
Master
Master

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.