Simple

[mazacini]

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?

[manas_bn · Accepted solution]

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;