First (100) SQL Select Distinct

[tinkerz1]

I would like to limit sql load to 1000 rows, that will really help me test, the SQL database is very large.

The code below is pulling all the data from sql, how can I limit this before a Qlikview preceding load?

Load *;

First (100) SQL SELECT DISTINCT * FROM xyz;

Thanks

Neil

[awhitfield]

Hi Neil,

makes sense to do this as a 'Limited Load' using the debugger, this sort of scenario is exactly what it's there for!

HTH

Andy