INCREMENTAL LOAD HELP PLS

[#1]

HI All,

I want to know how many new lines are fetched after incremental load?

i.e.,

In my qvd ,i have 500 files

after 1st incremental load, total 600 lines are fetched........

i.e., 100 records are new ones..

IS THERE any process to get how many new records are fetched to see in dashboard by using variable or something...........

[kaushiknsolanki]

Hi,

You can create an intermediate table (QVD) in incremental script, which stores the count of new records on day to day basis.

Regards,

Kaushik Solanki

[Anonymous]

hi ramya,

From QlikView Help

Trace

The trace statement writes a string to the Script Execution Progress window and to the script log file, when used.

It is very useful for debugging purposes. Using $-expansions of variables that are calculated prior to the Tracestatement, you can customize the message.

The syntax is:

trace string

Examples:

trace Main table loaded;

Let MyMessage = NoOfRows('MainTable') & ' rows in Main Table';

trace $(MyMessage);

[krishna_2644]

one trick:

put the expressions: 

LET vQVDRecordCounter= NoOfRows('FileName')   at the end of script;

and you can call the variable on UI.

[#5]

I didnt get you,

please elaborate & where i have 2 create intermediate script

{//This is my script

Incremental:

LOAD 

     Id,

     Sales,

    Modified_Date

FROM

(ooxml, embedded labels, table is Sheet1)where Modified_Date>$(Last_Updated_Date);

Concatenate

LOAD

     Id,

     Sales,

     Modified_Date

FROM

(qvd)Where not Exists (Id);

Inner Join

LOAD Id

FROM

(ooxml, embedded labels, table is Sheet1);

STORE Incremental into Sales.qvd;

DROP Table Incremental;

Pinky:

LOAD Id,

Sales,

Modified_Date

FROM

(qvd);

[jagan]

Hi Ramya,

You can try like below to store the new records count in variable

Incremental:

LOAD

     Id,

     Sales,

    Modified_Date

FROM

(ooxml, embedded labels, table is Sheet1)where Modified_Date>$(Last_Updated_Date);

LET vOldRecordsCount = NoOfRows('Incremental');

Concatenate

LOAD

     Id,

     Sales,

     Modified_Date

FROM

(qvd)Where not Exists (Id);

Inner Join

LOAD Id

FROM

(ooxml, embedded labels, table is Sheet1);

STORE Incremental into Sales.qvd;

LET vTotalRecordsCount = NoOfRows('Incremental');

LET vNewRecordsCount = vTotalRecordsCount  - vOldRecordsCount ;

DROP Table Incremental;

Pinky:

LOAD Id,

Sales,

Modified_Date

FROM

(qvd);

You will get the new records count in vNewRecordsCount  variable after execution of the script;

Hope this helps you.

Regards,

Jagan.

[#7]

Hi jagan,

Im getting OldRecords Count..

After Incremental table

u have written LET vOldRecordsCount = NoOfRows('Incremental');

This is new records count

[jagan]

Hi Ramya,

Try this

Incremental:

LOAD

     Id,

     Sales,

    Modified_Date

FROM

(ooxml, embedded labels, table is Sheet1)where Modified_Date>$(Last_Updated_Date);

LET vNewRecordsCount = NoOfRows('Incremental');

Concatenate

LOAD

     Id,

     Sales,

     Modified_Date

FROM

(qvd)Where not Exists (Id);

LET vRecordsInQVD = NoOfRows('Incremental') - vNewRecordsCount ;

Inner Join

LOAD Id

FROM

(ooxml, embedded labels, table is Sheet1);

STORE Incremental into Sales.qvd;

LET vFinalTotalRecordsCount = NoOfRows('Incremental');

DROP Table Incremental;

Pinky:

LOAD Id,

Sales,

Modified_Date

FROM

(qvd);

Hope this helps you.

Regards,

jagan.