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

[Anonymous]

If you use the load wizard for an excel file it will guide you through auto creating this script.  Also clicking on the Help button in the wizard will help you.

[MayilVahanan · Accepted solution]

Hi

Try like this

Sample 0.25 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$);

The sample prefix to a Load or Select (SQL) statement is used for loading a random sample of records from the data source.

[tresesco]

Or a customized script like:

FOR i=0 to 10

LOAD EmpID,

     [Last Name],

     [First Name],

     Title,

     [Hire Date],

     Office,

     Extension,

     [Reports To],

     [Year Salary]

FROM

(biff, embedded labels, table is Employee$) While RowNo()=Floor(Rand()*10*$(i));

Next i;

[Chanty4u]

thanks for diffrnt way  tresesco.

[Anonymous]

based on the id we can give the id <=10 than we get the out put

[Chanty4u]

thnkq sudhakar.