Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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;
thanks for diffrnt way tresesco.
based on the id we can give the id <=10 than we get the out put
thnkq sudhakar.