After limit load my file size still not reduce ?

[paulyeo11]

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

[Anonymous]

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,

[paulyeo11]

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

[manojkulkarni]

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

[Anonymous · Accepted solution]

Hi Paul,

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

best regards

[paulyeo11]

Hi Mauri

Thank you for your sharing

Paul