Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I Want to know the newly and added data count in incremental Load..

I want to like separate count newly and added data.. and total how many lines are newly and changed data  incremental load perform..

8 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

For historical and added records, you can use the NoOfRows() function twice (after the increment and after the historical addition or vice versa).

An incremental load can take care of replacing changed records, but since the implementation is entirely up to you, it would be difficult if not impossible to suggest a generic solution.

Care to provide a few more details about how exactly your incremental load is executed?

Best,

Peter

jagan
Luminary Alumni
Luminary Alumni

Hi,

You can add some kind of flag in your script to count the new records like below

Data:

SELECT

*,

1 AS NewData

FROM Data

WHERE Date = Trunc(SYSDATE - 1);

Concatenate(Data)

LOAD

*

FROM Data.qvd (qvd);

Now you can use Sum(NewData) to get the count of new records.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Is there any possible using text Box with expression. 

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try the above script and use below expression in the Text oject

='Newly added rows = ' & Sum(NewData)


Hope this helps you.


Regards,

Jagan.

Not applicable
Author

My Script Like this.. will say for this any solution for this query..

let vLMD=Now();

Incr:

LOAD EMPID,

     NAME,

     VALUE,

     LMD

FROM

D:\Qlikview\excel\incri.xlsx

(ooxml, embedded labels, table is Sheet1)

Where LMD > '$(vvLMD)';

Concatenate

LOAD EMPID,

     NAME,

     VALUE,

     LMD

FROM

D:\Qlikview\Practies\Incr.qvd

(qvd)

Where not Exists (EMPID,EMPID);

vvLMD=VLMD;

STORE Incr into Incr.qvd;

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

let vLMD=Now();

Incr:

LOAD EMPID,

     NAME,

     VALUE,

     LMD

FROM

D:\Qlikview\excel\incri.xlsx

(ooxml, embedded labels, table is Sheet1)

Where LMD > '$(vvLMD)';

LET vNoOfNewRows = NoOfRows('Incr');  // Variable to hold count of new rows, use this variable wherever you required.

Concatenate

LOAD EMPID,

     NAME,

     VALUE,

     LMD

FROM

D:\Qlikview\Practies\Incr.qvd

(qvd)

Where not Exists (EMPID,EMPID);

vvLMD=VLMD;

STORE Incr into Incr.qvd;

Regards,

Jagan.

Not applicable
Author

I want to only newly added and changed records.

Srinivas
Creator
Creator

Hi Jangan,

Can you send me sample application, that would more help for me.

Advance Thanks,

Munna