topic Re: Number of Rows Currently vs Number of Rows in Reload in QlikView

Number of Rows Currently vs Number of Rows in Reload

Mon, 10 Oct 2016 04:22:51 GMT

Hi all,

I'm wondering if the following is possible.

Lets say I do a load into a .qvw and it gives me 1500 lines of data.

1 week later I refresh the source file and hit reload and it gives me 1800 lines of data.

Is it possible to keep a history of this, where week 1 was 1500 lines and week 2 was 1800 etc.

Keeping in mind I'm not doing incremental loads for this just doing LOAD from and sometimes create QVD;s and load from the QVD etc and thus on each occasion the entire table gets dropped and the new data is populated.

Re: Number of Rows Currently vs Number of Rows in Reload

adamdavi3s — Mon, 10 Oct 2016 08:21:43 GMT

You could just store the date and rowcount into a QVD and then load that in each time?

Re: Number of Rows Currently vs Number of Rows in Reload

sunny_talwar — Mon, 10 Oct 2016 11:28:53 GMT

I agree with Adam. You can store that information in a QVD.

Table:

LOAD ....

FROM ....;

RowCount:

LOAD Week,

RowCount

FROM RowCount.qvd (qvd);

Concatenate (RowCount)

LOAD WeekYear(Today() as Week,

NoOfRows('Table') as RowCount

AutoGenerate 1;

STORE RowCount into RowCount.qvd (qvd);

Re: Number of Rows Currently vs Number of Rows in Reload

Mon, 10 Oct 2016 22:45:41 GMT

Thank you appreciate the help and your thoughts.