We have a requiement to read a flat file and nsert data to a table. I created a schema for the document. When I try to convert the flat file to schema its throwing an exception “delimiter not set”.
Could anyone letm e know why this is happening and how i can resolve it.
thanks in advance
Hi,
Since you are using must be using pub.flatfile.convertToValues to covert the flat file to IS document by validating against schema, you need to provide record delimiter and field delimiters in the input signature of this service.
Please set the segment and line delimiter from you sample file, it should solve your problem. Wrote us back if still find some issue.
cheers!
naren
The delimiters can be specified in the input of convertToValues or in the FF schema.