what is the fast way to extract large data

[#1]

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

[#2]

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;

[jagan]

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.