topic Re: After limit load my file size still not reduce ? in App Development

After limit load my file size still not reduce ?

paulyeo11 — Sun, 13 Sep 2015 12:39:07 GMT

Hi All

Recently i learn the below script :-

NewFilteredTable:

NOCONCATENATEMy imagine

LOAD *

RESIDENT TimeLine WHERE year='2015';

DROP TABLES TimeLine;

My imagination after i limit load year = 2015 , the file size never reduce. edit i think i know why.....

Paul

Re: After limit load my file size still not reduce ?

Anonymous — Mon, 14 Sep 2015 17:49:29 GMT

Hi,

I tried with some files here and the file get smaller.

Maybe, limit your load by year, doesn't affect too much the quantity of rows . You can try just load one line of your file and check if reduced or not.

Best Regards,

Re: After limit load my file size still not reduce ?

paulyeo11 — Mon, 14 Sep 2015 21:10:34 GMT

Hi Mauri

My issue is my Doc have many table , and for the sales table , i already load sample file , meaning my raw data file for sales table , i load very small file , so even i limit load by year , it will create any effect.

So my question now , it there any way i can know my data structure which table occupy how many Mb data ? So that i will know which table need to limit load.

Paul

Re: After limit load my file size still not reduce ?

manojkulkarni — Tue, 15 Sep 2015 04:33:02 GMT

You have option of Limited Load , where in you can define no of rows to be loaded.

Go to Edit Script - Debug - Check Limited Rows

Re: After limit load my file size still not reduce ?

Anonymous — Tue, 15 Sep 2015 13:28:21 GMT

Hi Paul,

You can try store the tables you load in qvd and check the size of each table (qvd) .

best regards

Re: After limit load my file size still not reduce ?

paulyeo11 — Tue, 15 Sep 2015 13:34:57 GMT

Hi Mauri

Thank you for your sharing

Paul