Limit Number of Rows Loaded

[evansabres]

Is there a way within the scripting to limit the loading of data to the first 'X' number of rows?

[rupamjyotidas]

There are some ways.

Load Top 10

Or

You can write a where statement like

Load *

From xyz.qvd where row()<100

[nagarjuna_kotha]

Yes ,

Debug option is there to load llimited numer of records

[sunny_talwar · Accepted solution]

May be like this:

TableName:

First 1000

LOAD .....

FROM....;

or

TableName:

LOAD ...

FROM...

Where RowNo() <= 1000;