Incremental Load on multiple columns

[knightrider]

Hi ,

 Been using QVC quite sometime now. Calendar,Min, Max, Incremental Load etc..

Now was wondering how to extract delta with multiple fields as , say, composite key. The function normally returns a where clause on one field, isn't it? Any mechanism to achieve the same with a combination like ID and DateModified?

Thanks in advance, 

-knightrider

[Barry Harmsen]

Hi,

I just add a field containing the composite key to the QVD, this adds a little data but works fine.

Cheers,
Barry

[i.do...@fusionsystems.nl]

Hi Barry,

How would you go about having the composite key in an incremental load?

Do you have an example ?

Cheers,

Ingolf

Op dinsdag 31 juli 2012 09:07:21 UTC+2 schreef Barry Harmsen:

[Rob Wunderlich]

I just create the additional field in the LOAD like:

LOAD 

OrderID & '-' & LineNo as %OrderKey, // Create Primary Key

Kind Regards,

Rob Wunderlich

http://MastersSummit.com   @QlikMasters

http://QlikviewCookbook.com   @QVCookbook

--
You received this message because you are subscribed to the Google Groups "Qlikview Components Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to qlikview-component...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.