topic first 100 in data connection (select data to load dialog) in App Development

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

ingo_lsg — Sat, 16 Nov 2024 18:24:35 GMT

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?

kaushiknsolanki — Mon, 06 Jul 2020 07:45:42 GMT

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.

NitinK7 — Mon, 06 Jul 2020 08:26:13 GMT

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

write limit 100 in your sql statement

ingo_lsg — Mon, 06 Jul 2020 11:03:12 GMT

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