RE:Load Only

[Chanty4u]

Hi all ,

I have one excel data.  with in that  i want to load only  last 10records of data only?

how can i load dis data in qvw?

Thanks in advance

Suresh

[tamilarasu]

Hi Suresh,

Table:
LOAD EmpID,
     [Last Name],
     [First Name],
     Title,
     [Hire Date],
     Office,
     Extension,
     [Reports To],
     [Year Salary],
     RecNo() as RecNo
FROM
[..\Desktop\EmpOff.xls]
(biff, embedded labels, table is Employee$);

LET a = Peek('RecNo');

NoConcatenate
Final:
Load*
Resident Table Where RecNo>= $(a) -9;

DROP Table Table;

[MayilVahanan]

Hi

Try like this

Temp:

LOAD EmpID,

     [Last Name],

     [First Name],

     Title,

     [Hire Date],

     Office,

     Extension,

     [Reports To],

     [Year Salary],

     RowNo() AS Row

FROM

EmpOff.xls

(biff, embedded labels, table is Employee$);

NoConcatenate

First 10 LOAD * Resident Temp order by Row desc;

DROP Table Temp;

[avinashelite]

You can also try like ...

sort your excel file in descending order and then use the

first 10 function

hope this might also help you

[Anonymous]

Or maybe like this

LOAD EmpID,

     [Last Name],

     [First Name],

     Title,

     [Hire Date],

     Office,

     Extension,

     [Reports To],

     [Year Salary]

FROM

EmpOff.xls

(biff, embedded labels, table is Employee$, filters(

Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 11), Select(1, 0)))

));

This should be efficient as it only loads the last 10 rows, as opposed to loading all rows and then discarding the unwanted rows.

[sunny_talwar]

Try this:

Table:

Directory;

LOAD EmpID,

    [Last Name],

    [First Name],

    Title,

    [Hire Date],

    Office,

    Extension,

    [Reports To],

    [Year Salary]

FROM

EmpOff.xls

(biff, embedded labels, table is Employee$, filters(

Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 11), Select(1, 0)))

));

[Chanty4u]

thnks sunny,

can u explain how this works?what it exctly does?

filters(

Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 11), Select(1, 0)))

));

[Chanty4u]

Thnks all for ur inputs on this.

[Chanty4u]

if i want to load random data of 10 records only how can do that?

[avinashelite]

Try like this

Sample 0.10 Select * from Longtable;