Discussion Board for collaboration on QlikView Scripting.
I have to preaggregate about 36 months separately. then bring them all together into one table (the tables have the same formats).
What is the easiest way to concatenate this many tables (ie the best scripting)?
My tables are:
...and so on
Assuming you know all the tables in advance...:
LOAD * INLINE [Period];
For Each i In 'Jan2012','Feb2012','Mar2012'
'$(i)' AS Period,
(ooxml, embedded labels, table is $(i));
I have used an example where each table is a sheet in an Excel workbook so you'll need to adjust for your data source.
Hope this helps,