Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
replace field list with *
For example: Crosstable (PeriodX, Value, 1) LOAD * FROM ...
RudyK
Hi,
replace field list with *
For example: Crosstable (PeriodX, Value, 1) LOAD * FROM ...
RudyK
Thank you