Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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.