Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
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?