If the data volume is huge, which approach is better? Our source data is stored in excel. So using the excel as data source or loading the data to a database like SQL server and using that as data source?
If the data is in Excel and the objective is to get it into Qlik then I would do it directly Excel into Qlik, as I can see no benefit of adding a database load / extract into the processing chain.
I am curious what your definition of huge is. I seem remember the maximum Excel can handle is about a million rows, but I could well be wrong about that.
what about 1 million rows from excel source? Will that be an issue from the "app data reload" point of view? And what about storing the excel? I am thinking it has to be placed in a server folder or in a shared folder which can be accessed by both server and developer machines. Will that be a problem?
If ur data is excel, it cannot be qualified as huge. (since excel has a limit for about a million of max rows.., which is qualified as TINY for Qlik Sense)
Currently I am not working with any huge files. This is for a future app proposed by client. They say they have data in excel files and the data size is huge. So I just want to be sure so that we don't run into problems later, both development and maintenance point of views.
.png "Luminary Alumni"){kind=icon}
