Dynamic read of Excel sheet, if values get added

QFanatic — Mon, 12 Apr 2021 08:52:53 GMT

hi there

I am reading a pivot table from Excel (I'm attaching a similar layout just as example)

These are figures for actuals that gets added every month. So I dont want to go and edit the model to add another month.

My script currently looks like this:

Messaging_t: //Pivot = Pg 1, Middle
crosstable(PeriodX,Value,1)
LOAD
Services,
[Jul 19],
[Aug 19],
[Sep 19],
[Oct 19],
[Nov 19],
[Dec 19],
[Jan 20],
[Feb 20],
[Mar 20],
[Apr 20],
[May 20],
[Jun 20],
[Jul 20],
[Aug 20],
[Sep 20],
[Oct 20],
[Nov 20],
[Dec 20],
[Jan 21],
[Feb 21] //will have to add new months manually

FROM
[$(vQvDataMessRead)SomeFile.xlsx]
(ooxml, embedded labels, header is 1 lines, table is [Example])
where recno() < 11;

Would it be possible to change the read script so that it reads everything?

Much appreciated.

Re: Dynamic read of Excel sheet, if values get added

RudyK — Mon, 12 Apr 2021 09:07:56 GMT

Hi,

replace field list with *
For example: Crosstable (PeriodX, Value, 1) LOAD * FROM ...
RudyK

Re: Dynamic read of Excel sheet, if values get added

QFanatic — Mon, 12 Apr 2021 09:24:23 GMT

Thank you

topic Re: Dynamic read of Excel sheet, if values get added in QlikView

Dynamic read of Excel sheet, if values get added

Re: Dynamic read of Excel sheet, if values get added

Re: Dynamic read of Excel sheet, if values get added