Hi,
I have been using cloverETL for processing falt files with header and it works great.
Now I also need to process a flat file which does not have a header. So I was using the first data row in the file for defining the metadata and the mappings and perform the transformation.
The issue I am facing there is that the data row contains columns with just numbers or certain special characters which do not form a valid clover metadata for mappings.
What would be the alternates for processing a flat file without a header or defining a valid mapping for a headerless file?
Regards
Pankaj
I have been using cloverETL for processing falt files with header and it works great.
Now I also need to process a flat file which does not have a header. So I was using the first data row in the file for defining the metadata and the mappings and perform the transformation.
The issue I am facing there is that the data row contains columns with just numbers or certain special characters which do not form a valid clover metadata for mappings.
What would be the alternates for processing a flat file without a header or defining a valid mapping for a headerless file?
Regards
Pankaj
-
Hello,
flat file Readers can't do any mappings between metadata and data in the file; they read the data sequentially and parse it according to metadata. If you have flat file with header, all you can do is to skip first row. For file without the header just do nothing - provide only file url in the Reader.
Please sign in to leave a comment.
Comments 1