topic Data limit in QlikView

Data limit

Mon, 03 Nov 2014 12:15:41 GMT

Hi,

in excel file contained 1 Lack rows.

I want only first 50000 by date field,

Already

a 'date' filed column exists in excel table.

And also explain how to retrieve in database?

Regards

Re: Data limit

MK_QSL — Mon, 03 Nov 2014 12:20:35 GMT

Load

RowNo() as ID,

Field1,

Field2

From TableName

Where RowNo() <= 50000;

Re: Data limit

MarcoWedel — Mon, 03 Nov 2014 13:10:56 GMT

First 50000

Load fields

From excelsource;

Re: Data limit

MarcoWedel — Mon, 03 Nov 2014 13:12:10 GMT

First 50000

Load fields

From excelsource

Order By date;

Re: Data limit

ashwanin — Mon, 03 Nov 2014 13:12:58 GMT

use first 50000 in script

First 50000

Load*

from axyj.xls

Re: Data limit

its_anandrjs — Mon, 03 Nov 2014 14:53:36 GMT

Hi,

There are many ways

1. By load script

First 50000

Load

FieldNames

From Source;

2. By Rowno()

Load

From Location

Where Rowno() <= 50000;

2. By pressing Ctrl + E in load script

Then press debug and then define Limited Load and enter no of rows as 50000

Regards

Anand