Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Paul,
You can try store the tables you load in qvd and check the size of each table (qvd) .
best regards
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,
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
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
Hi Paul,
You can try store the tables you load in qvd and check the size of each table (qvd) .
best regards
Hi Mauri
Thank you for your sharing
Paul