https://community.qlik.com/t5/Talend-Studio/Reject-larger-records-from-fixed-with-files/m-p/2326381#M95875 <P>first step you can do is, pass length of record as parameter from parent job and in child job first reject all the records greater than len of rec using filter component and good record load in DB.</P> Thu, 18 Feb 2021 19:16:54 GMT sagu 2021-02-18T19:16:54Z https://community.qlik.com/t5/Talend-Studio/Reject-larger-records-from-fixed-with-files/m-p/2326380#M95874 <P>I have built a generic job which loads fixed width files to appropriate tables, by parameterizing the files positional info and the table name using the dynamic option in </P><P>tfileinputpositional and tDBoutput, component but sometimes the file may contain characters which are larger than the expected number of characters, in that case I want to reject those records, I'm not finding any option find the length of all dynamic column characters, is there any way to achieve this?</P><P></P><P></P><P></P><P></P><P>tfileinputpositional-----------&gt;tmap-----------&gt;tDBoutput</P><P></P><P></P><P>thanks</P><P>MJ</P> Mon, 15 Feb 2021 22:27:09 GMT https://community.qlik.com/t5/Talend-Studio/Reject-larger-records-from-fixed-with-files/m-p/2326380#M95874 borrisbeck 2021-02-15T22:27:09Z https://community.qlik.com/t5/Talend-Studio/Reject-larger-records-from-fixed-with-files/m-p/2326381#M95875 <P>first step you can do is, pass length of record as parameter from parent job and in child job first reject all the records greater than len of rec using filter component and good record load in DB.</P> Thu, 18 Feb 2021 19:16:54 GMT https://community.qlik.com/t5/Talend-Studio/Reject-larger-records-from-fixed-with-files/m-p/2326381#M95875 sagu 2021-02-18T19:16:54Z