Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
4 Replies
Not applicable

incremental reload with unique key

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

incremental reload with unique key

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

incremental reload with unique key

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
Not applicable

incremental reload with unique key

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.