Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
TigerisBack
Champion
Champion

how to load 2gb data without increasing the configuration

hello all,

I have 2gb of data file which is in csv.i have 2GB RAM.

I am not able to load file. is there any way we can compress data  without increasing the system configuration.

Regards

Sunil Chauhan

12 Replies
kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

     Why dont you create a QVD of that CSV file and then try to load in QlikView.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
mall1m
Partner
Partner

are you able to split data through several smaller QVD ?

for example, loading 1 year at a time, storing each year in a dedicated QVD

"FOR LOOP"

my_table

LOAD * FROM mycsv WHERE year=vYear

STORE mytable INTO mytable & vYear.QVD

DROP my_table

TigerisBack
Champion
Champion
Author

Thanks

@mall1m:i dont want to break the  into qvd's

@Koushik: i aam not able to load csv then how can i able to create qvd.

Please ssuggest some other ways .

kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

     I think the way could be devide the data into QVD's. Say for example for one year or on another basis.

     And then again create a QVD whith combined data from all small QVD's and then try to load it.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
TigerisBack
Champion
Champion
Author

@Koushik : i also thing to do this way.

but i want to load at once.

is it possible

kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

     Not possible the reason is while loading data QlikView loads data in RAM, and if you have less RAM then there is no chance.

     I dont know if it can be done by increasing the virtual memory.

     Just try that.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
TigerisBack
Champion
Champion
Author

thanks kousshik,

how to increase virtual memory.

kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

     Go to Control Panel -> System -> Advanced System Settings -> Advanced tab -> Performance -> settings -> Advanced tab -> Virtual memory.

     This is for Windows 7.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
TigerisBack
Champion
Champion
Author

but virtual memory also depends on Ram.

so do you thing will it be helpful