You are not logged in.
We have multiple text files that have records in various formats as below, all fixed length without any delimiters:-
There are multiple formats in each file, but all lines have the same total length (136).
Each different record format (BSP..1 thru BSP..99) needs to inserted into different Postgres database tables. Is there a way in TIS to iteratively read records from files, then based on values of the first 3+8=11 positions, insert the rest of the fields into different tables? Note that the rest of the fields are of different lengths for each format.
For example, all BSP00000001… lines of files need to go into table:
processing_time TIME WITHOUT TIME ZONE,
All BSP00000002… lines of files need to go into table:
and so on.
I would greatly appreciate if you could help us out. TIS version is:
Talend Integration Suite - Enterprise Edition
Build id: r22547-20090316-1930
you could read your data with tFileInputPositional and three columns (3,8,rest). Then use tMap to split your data into different output streams depending on the first two fields. Each stream will get its own tExtractDelimitedFields, output component and whatever is needed to process the data.
In 3.1 new multi schema components are added. For example "tFileInputMSPositional" but I never used them until now.