FileList in TPT

Database

FileList in TPT

Hi

I want to load multiple files into one target table, every file has the same structure so I want to use only one File Reader.

I have defined:

VARCHAR FileList = 'Y',
VARCHAR ARRAY = ['file1.txt','file2.txt']

and I get following error:

TPT19205 Attribute 'FileName' value is invalid. Value provided was 'Multi-value'. Valid values are 'Single-value'.

According to TPT Reference the FileName should be a list containing file names, what is wrong here?

Thanks for help
traufe
Tags (3)
1 REPLY

Re: FileList in TPT

Hi, Use attribute VARCHAR FileName ='File*.txt' or '*' ,This will read all the files filename start with 'File' (File1.txt,File2.txt).

Please let me know if you need more details.
Thanks,
Krishna