Remove source file totals line
I have a simple text schema for a file that has a Totals line at the end of the file. The file processes the lines of the file fine but the process flow summary shows 1 record error from the totals line. How do I get rid of or skip the totals line?
-
Since your text file has two types of records (data and the totals line), then you can create an advanced text schema to handle both types of records. For more information, you can refer to the developer guide (Help > Developer Guide)
Home > Creating Schema Activity > Creating Advance Text Schema Activity
Also, you can choose to ignore the Error Records generated by the text schema. Within the process designer, select the Ignore option of the Error Records property of the Text Schema.
0
Post is closed for comments.
Comments
1 comment