Creating Extraction Fields by Importing a Layout File

OL Connect Professional DataMapper
1

I have an input file in TXT format with fixed columns, with 1 record per line. Each record has 2100 fields. I have the field mapping in an Excel file, which specifies the field name, the start of the field, the end of the field, and the field size.

I would prefer not to map each field individually, due to the significant amount of manual work involved. Is it possible to import this Excel file, or another file format, into DATAMAPPER, where it will then define the field extraction according to the layout defined in Excel?

2

Hello @Marcvia,

Can you describe a situation please in which you would like to extract data from a data file in TXT format with that many fields? The reason why I’m asking is because it isn’t a good idea to configure a datamapper with dynamic field names and column widths, especially with that many fields – sooner or later you will run into (performance) issues.

Caution: It is recommended not to share any sensitive information.