First row from multiple txt files

[jademcmanus]

I have 360 files I need just the first row from. I'd like to get them into SQL or a txt file and load that into SQL. 

[DavidP]

You can set the record limit to 1 in option 1 of the input data tool and load them with a wildcard option (*.txt) in the file path specification.

[robertporternz]

Hi there, I tried this approach and it was only bring back 1 record and stopping after the first file, is there a way to make this persist across all files that are using the wildcard option specs?

[ddiesel]

Hi @robertporternz!

Here's something you can try:

Tips:

* In the Directory tool, be sure to specify the file type (i.e. txt)

* You can place a filter tool between the Directory and Dynamic Input if there is a specific file name schema

* Chose a "trainer" file in the Dynamic Input tool and set the record limit to 1

Hope this helps!

Deb

[robertporternz]

Totally thanks so much that was really helpful @ddiesel