Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ingo_lsg
Contributor III
Contributor III

first 100 in data connection (select data to load dialog)

Hi Experts,

when connecting to a SQL table with lots of data rows the data preview takes very long.

Is here also a possibility to use the function first x (e.g. 100) rows?

Maybe in the filter list box?

 

ingo_lsg_0-1594019659586.png

 

Labels (3)
3 Replies
kaushiknsolanki

Hi,

I don't think so there is any way from the wizard, but you know the table name, you can write the SQL directly in the script.

This will save a lot of your time. 

If you don't know the fields, use *, to load all fields, and then use resident load to remove unwanted fields.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
NitinK7
Specialist
Specialist

Hi,

there is no option to load only 100

you can insert script first and write your script like

First 100 load your filed

          from fillepath

or 

write limit 100 in your sql statement

    

ingo_lsg
Contributor III
Contributor III
Author

Is there any other way to speed up the preview in the wizard?