Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Only get new data

Hi,

I have a QVW that I use for sending reports through nprinting. This QVD is scheduled to run every 5 min to catch new information.

Is it possible to in npritning send only the new information between the latest interval so to speak.

I don't know maybe I explain myself badly.

But if they get a file 09:00 with some information and new information comes in 12:05 they only want this new information not the info that was in the old file.

3 Replies
avinashelite

Best way would be is to add a flag in Qlikview for the latest data and in NPritning apply the filter for latest flag so that you could have more flexibility.

Not applicable
Author

Sounds great how would Implement this flag?

avinashelite

I don't have info about your data ..

If you have implemented incremental logic then based on the time stamp you can create this flag like

Let vLastReload=  //your last reload time

then in the data table

LOAD *,

If(date/Time_field  >vLastReload,1,0) as NPritign_Flag

;

Or if its on the key then you might be using to tables

Old_date:

LOAD

Key,

if(NPritign_Flag=1,0,0) as  NPritign_Flag

...

from

History;

New:

LOAD

Key,

1 as  NPritign_Flag

...

from

New

where exist(Key,Key);

hope you got the idea