SP

• Dec 11th, 2017

 

1. View data and get the malformed record using m_dump. Note down that record number(s).
2. Using Filter by Expression, deselect only that/those record(s).
3. Using Reformat, specify values manually for each field (to generated one correct record. Repeat step 3 if records are more)
4. Pass that/those record(s) to Merge component where the selected records and this/these record(s) will be merged and sent to a new multifile.

Mahesh

• May 26th, 2021

 

To check malformed records you can use m_dump -partial option.This option shows any incomplete records.Else run the graph and attach a reject and error port to see