Hi all, this is my first time here, and I hope anyone could help me.
I need to know if it is possible to create multiple output files by using TPT, but every output file name must be created based on the value of a table field.
I have a table with hundred millions rows, and two files: Filename and Type.
I need to download that table on multiples files, as many as different filename values I have in that table.
According to the example I would obtain three output files, F1, F2, F3, whose content would be:
For output file "F1":
For output file "F2 ":
For output file "F3":
As the amount of files to be produced, as well as their names, are variable and uncertain, is there any way to do it by using any kind of definition in tpt based on arrays or dynamic filelist or whatever?
I've been diving a lot but I couldn't get any example.
Thanks a lot
"Derived" file names is not currently supported in TPT.
The file writer operator has no knowledge of where the data came from.
It just receives rows of data from the operator that is pulling data from Teradata.