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.
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.
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?
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
Totally thanks so much that was really helpful @ddiesel