TPT load sourcefile name character matching

Tools & Utilities

TPT load sourcefile name character matching

I want to load files with names like abc18.dat,abc19.dat,.. to my teradata table.

the numeric part of file name is going to be two digits which is not known.

I cannot use abc*.dat because i have other files like abcdef.dat.

 

abc[0-9][0-9].dat is not working in TPT.

 

What are the alternatives?

 

1 REPLY
Junior Contributor

Re: TPT load sourcefile name character matching

If you can't move those files into an empty directory, you can use the FileList option:

Create a flat file first (e.g. using ls&grep on Linux) with all the file names and then use this in the FileList.