Discussion board where members can get started with Qlik Sense.
I want to load my data through Data Manager.. is there any way I can limit the data before I load/prepare it? I'm loading huge data coming from my database and I do not want to load all! Is there any way I can filter my data?
Thanks in advance,
Go to Solution.
Not in the Data Manager afaik. But I haven't used it a lot yet. Perhaps it's possible to add a WHERE clause when selecting the data source.
In the Date load Editor you can add a line directly above the load statement to limit the number of records that will be loaded:
LOAD A, B, C FROM ...;
If you use Debug Mode you can also use the Limited Load setting to restrict the number of records loaded. See the online help for more information: Debug the data load script ‒ Qlik Sense
as gwassenaar said not possible in Data manager. you can do it in data load editor.
Thanks for the input! arulsettu and gwassenaar