Simple

mazacini — Wed, 04 Sep 2013 22:14:33 GMT

I am trying to create a small table with the file dates of 2 files.

I have 2 load statements

Date1:

LOAD (FileTime()) as FileDate

FROM File1;

and similar for File 2.

I expected to get 2 records, one for each File Time. However, the files contain 1,000 lines each. I end up with 2,000 lines in my Date1 table.

What am I doing wrong?

Re: Simple

manas_bn — Wed, 04 Sep 2013 22:22:42 GMT

First prefix should work (assuming you are getting 1000 records each with the same date/time...

Date1:

First (1) LOAD (FileTime()) as FileDate

FROM File1;