https://community.qlik.com/t5/Talend-Studio/Rejected-rows-not-captured/m-p/2262952#M43257 <P>I am moving a large amount of data (over 30 million rows) and getting a different count between the source and destination.</P> <P>&nbsp;</P> <P>My source database is SQL Server and destination is Snowflake.</P> <P>&nbsp;</P> <P>Even though I have added a reject route to an delimited file - I am not getting anything in the reject file.</P> <P>&nbsp;</P> <P>Here is a screen shot of my job.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="audititem1.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1X4.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136865i956DE693AB083B46/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M1X4.png" alt="0683p000009M1X4.png" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="audititem2.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1Lu.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133054i89420E0DB22FB761/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M1Lu.png" alt="0683p000009M1Lu.png" /></span></SPAN></P> Sat, 16 Nov 2024 07:15:09 GMT talendstar 2024-11-16T07:15:09Z https://community.qlik.com/t5/Talend-Studio/Rejected-rows-not-captured/m-p/2262952#M43257 <P>I am moving a large amount of data (over 30 million rows) and getting a different count between the source and destination.</P> <P>&nbsp;</P> <P>My source database is SQL Server and destination is Snowflake.</P> <P>&nbsp;</P> <P>Even though I have added a reject route to an delimited file - I am not getting anything in the reject file.</P> <P>&nbsp;</P> <P>Here is a screen shot of my job.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="audititem1.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1X4.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136865i956DE693AB083B46/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M1X4.png" alt="0683p000009M1X4.png" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="audititem2.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1Lu.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133054i89420E0DB22FB761/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M1Lu.png" alt="0683p000009M1Lu.png" /></span></SPAN></P> Sat, 16 Nov 2024 07:15:09 GMT https://community.qlik.com/t5/Talend-Studio/Rejected-rows-not-captured/m-p/2262952#M43257 talendstar 2024-11-16T07:15:09Z https://community.qlik.com/t5/Talend-Studio/Rejected-rows-not-captured/m-p/2262953#M43258 <P>Hello,</P> <P>What's operation are you using in tMap component? Would you please let us know which steps your row count is changed? Row1 or AUDITITEM? Could you please try to use tLogRow instead of an delimited file to see if your rejected rows are captured on console?</P> <P>Best regards</P> <P>Sabrina</P> Tue, 27 Nov 2018 06:24:52 GMT https://community.qlik.com/t5/Talend-Studio/Rejected-rows-not-captured/m-p/2262953#M43258 Anonymous 2018-11-27T06:24:52Z