distinct incremental load not perofrming

singhcv123 — Fri, 18 Nov 2016 07:18:02 GMT

Hi,

I am middle of one scenario , which is quite new for me....the secenrio is :

i have 2 tables :

Travel and travel package.

I want to load travel table and only want to generate distinct travel package given in travel table.

Travel given below

Travel

++++++++++

Travle ID Travel Package

T001 P01

T 002 P02

T003 P03

T004 P04

Travel Package

+++++++++++++++++++

Package ID Package Name

P01 Package 1

P02 Package 2

P03 Package 3

Now in my scenrio every day i am gettng more than 100 rows in Travel table and i want to generate distinct Travel package in "Travel Package" Table.

Now the problem is while going incremental i am not getting right data in Travel package table.

FOr examle:

Currently in Travle table having 100 rows and Travel package P01 to P05

than Travel Package Table should show P01 to P05....

Next day i am getting incremental data and another 100 rows in Travel Table and having Travel Package P01--to -P07

than only P06 and P07 to add in Travel Package and our final table should show P01---to P07...

should be in incremental.....

please suggest

Re: distinct incremental load not perofrming

jonathandienst — Fri, 18 Nov 2016 07:27:26 GMT

i am not sure what your problem is. Just incrementally load the Travel Package table as well. You could use a WHERE Not(Exists(PackageID)) type of construct (before you load the Travel table).

topic Re: distinct incremental load not perofrming in QlikView

distinct incremental load not perofrming

Re: distinct incremental load not perofrming