Number of Rows Currently vs Number of Rows in Reload

[#1]

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.

[adamdavi3s]

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

[sunny_talwar · Accepted solution]

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);

[#4]

Thank you appreciate the help and your thoughts.