Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a large table with 246 column .
When I try to extract all the data at once , it cause me a problem: it take long time and after a while it losing connection ( the server is in another country) .
I notice that if I take one year it work fast, so I am thinking to run per year and save it to QVD, then I will union all years into one table via qlikview .
My question is :
I want to extract the data per year and I need it to run parallel way ( I do not to extract year 2007 and then year 2008 etc… )
How do I do that ?
Do I need to build qwv per year ?
Or maybe you have other solution ?
Thank you
thank you
i took your example and run it , i got one row
with Dim1 and Dim2 columns
values , 0,10.
ok but if we reffer about youe solution , why do i need the :
Data:
Load
Dim1,
Dim2
AutoGenerate 1;
Hi,
It shoule be
Data:
Load
0 as Dim1,
0 as Dim2
AutoGenerate 0;
This just creates table with two columns and zero rows.
Regards,
Jagan.