Discussion Board for collaboration on QlikView Publisher.
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) :
field1, field2, field3, field4, field5, field6,
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??
I tried also with:
SQL SELECT * FROM TABLE where (field7= 'X' or field7= 'Y') and not exists(field1&field2&field3&field4&field5&field6) ;
SQL SELECT * FROM TABLE where not exists(field1&field2&field3&field4&field5&field6) ;
but don't work
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
thanks for your message
but it's impossible to have a complex syntax to where?
where field1 CA 'XY' and field2 > 1000
where (field1 = 'X' or field1 = 'Y') and field2 > 1000
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.