Hello Sir / Madam,

I would like to ask for your expertise regarding this concern. Is there any way we can create flat file schema based on the input file provided?

The reason for this is because the input file doesn’t have fixed column per line and they are using EFF file not CSV nor fixed length.
Kindly advise.

Hi Wilmor,

Yes we can create flatfile schema based on the input file.
Please refer to documentation for more details.

If input file doesn’t have fixed column per line, you should create number of possible fields in the schema.
And all the fields should be set mandatory to false.

Thanks,
Mario Roche

Thank you, Mario!