Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
i am loading on e excel sheet with having 1 to 100 records in a excel sheet. Now i want shows the exact records of 51,54 and 99
thanks in advance
Try like this:
ABC:
Load
A,
B,
C,
RowNo()
from ABC.xls;
NoConcatenate
Temp:
Load
*
Resident ABC
where Macth(RowNo(),51,54,99);