Limited import for development mode

[fabricius]

How do I limit the amount of entries to be imported as I am working in "development mode" and do not want to wait for minutes every time a refresh is done?

[alexandros17]

If you have a date set that date to an interval, for example:

select

...

from

...

where date >= 01/01/2014 and date <= 31/01/2014;

The same if you have a id field, the logic is set interval on significative fields.

Let me know

[Anonymous]

When in the script editor

• Click <Debug>
• Tick Limited Load
• Enter number of rows
• Click <Run>

[struniger]

Hi Soren,

Lookup the FIRST statement:

First 10 LOAD * FROM abc.csv;

Best regards

Stefan

[MarcoWedel]

In the script debugger you can select the number of rows to be imported.

regards

Marco