Qlik Community

Deployment Framework

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
munna1317
Creator II
Creator II

Reducing data at the time of load

hi ,

ply help me in this scenario ,

the requirement is at the time of loading data from data sources we can reduce the data in row wise .

that means example :

i have table "Product.sales"

with field name "Production_sales" i have 10 million rows in this field how can reduce the data at the time of reload.

Regards ,

Harish

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Load * From TableName Where Year > 2014;

Or

Load

     CustomerID,

     CustomerName,

     CustomerCountry,

     .....

From TableName

Where Match(CustomerCountry,'UK','Germany','France');

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Load * From TableName Where Year > 2014;

Or

Load

     CustomerID,

     CustomerName,

     CustomerCountry,

     .....

From TableName

Where Match(CustomerCountry,'UK','Germany','France');

munna1317
Creator II
Creator II
Author

thanks Manish Kachhia