first 1000 rows in each any every log file

[#1]

Hi,

       I have folder in that folder i have 31 log files(flat file) each of have huge data

      Now i want first fetch the first 1000 rows in and every log file

       can u help me

[its_anandrjs]

Load like for all flat file use *

Load * From

Flat file location where Rowno() < 1000;

[#3]

Actually  i am  trying with below script but am getting the one log file date the loop will not be repeated

For Each zFile In FileList('C:\Users\Administrator\Desktop\TTSL_Aug_logs\AP\*.txt')

AP:

LOAD CALLID,

     CLI,

     STARTDATETIME,

     CATEGORY,

     MENULEVEL,

     MENUPATH,

     ENDTYPE,

     IVRDURATION,

     ARPU,

     TRANSCODE,

     LANGCODE,

     SUBCATEGORY,

     LASTMENUACCESS,

     DISPOSITION,

     CCNAME,

FROM

[$(zFile)]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where RowNo()<=1000;

next;

[sudeepkm]

similar question in another thread.

You can use

First 1000

load * from *.log;

[sudeepkm]

I'm sorry I could not get your point

"am getting the one log file date the loop will not be repeated"

have you tried using the debugger. you can find why it is not able to read other files. and why the loop exits.