How to use Buffer Load when Script has Group by and Resident Tables.
Good day to all of you,
I built an application in Qlik Sense Desktop which is using data from txt files that contain an average of 2 million registers per month, this app has to be updated every month containing the data from the actual and the previous months also.
My problem is that currently the app has too many data and is working really slow, so what I thought to do is to load the info using SUM and COUNT formulas and grouping the data with 'group by' and 'resident' tables but I noticed that Buffer Incremental Load doesn't works when grouping data like that,
I'm still kinda new in Qlik Sense, and don't know if there are other ways to do this, maybe you can recommend me tutorials for loading data properly or any other kind of advice, doesn't matter if the explanations are advanced I will take the necessary time to understand it.