Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

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

MVP
MVP

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

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

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

Is there any possible using text Box with expression. 

MVP
MVP

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

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

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

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;

MVP
MVP

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

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

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

I want to only newly added and changed records.

munnareddy
Contributor

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

Hi Jangan,

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

Advance Thanks,

Munna

Community Browser