Sef
VIP Member
Hi All,
The table conversion tool facilitates the conversion of data in text format directly into One World tables. I now have the need to convert a number of identically structured text files into the one One World table (the text files are supplied per state rather than consolidated). However the TC tool only allows one file name. Also when I try to copy one TC UBE into another and change the input file name, all ER and File format information is deleted, so I need to design 8 (one for each state) quite involved UBE's.
The alternative is to rename the text file every time prior to running the TC UBE, but this seems rather cumbersome. And consolidation is also quite tricky as each file contains two header records which contain information on eg state.
Is there a method where the text file name can be a variable eg dependent on a Processing Option or read from a table? Is there maybe another method I can use?
Any help or tips would be greatly appreciated
Rgds,
The table conversion tool facilitates the conversion of data in text format directly into One World tables. I now have the need to convert a number of identically structured text files into the one One World table (the text files are supplied per state rather than consolidated). However the TC tool only allows one file name. Also when I try to copy one TC UBE into another and change the input file name, all ER and File format information is deleted, so I need to design 8 (one for each state) quite involved UBE's.
The alternative is to rename the text file every time prior to running the TC UBE, but this seems rather cumbersome. And consolidation is also quite tricky as each file contains two header records which contain information on eg state.
Is there a method where the text file name can be a variable eg dependent on a Processing Option or read from a table? Is there maybe another method I can use?
Any help or tips would be greatly appreciated
Rgds,