https://community.qlik.com/t5/Talend-Studio/Talend-TOS-CRC-tAddCRCRow/m-p/2364072#M127870 <P>Hello,</P><P>I'm looking to get a crc32 from a csv file or a sql table whatever (example: 2 columns and 2 rows).</P><P>with the tAddCRCRow I manage to get the CRC of each line but not of the complete file (see images).</P><P>How can I proceed to have a single CRC and not one per row ?</P><P>I was thinking of storing the whole file in a buffer to transform it into a single column and a single row (like a concatenation) but I don't know how to do this</P><P></P><P></P><P>Thank you for your help.</P><P></P><P></P><P>csv file exemple :</P><P></P><P></P><P>colonne1; colonne2</P><P>100; 200</P><P>150; 350</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Ibwz3AAB.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143507iC1011B29DE6ADF2A/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000Ibwz3AAB.jpg" alt="0695b00000Ibwz3AAB.jpg" /></span></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000IbwzDAAR.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129756iB0B8A6698363F297/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000IbwzDAAR.jpg" alt="0695b00000IbwzDAAR.jpg" /></span></P><P></P><P></P> Fri, 15 Nov 2024 23:47:15 GMT obenabed 2024-11-15T23:47:15Z https://community.qlik.com/t5/Talend-Studio/Talend-TOS-CRC-tAddCRCRow/m-p/2364072#M127870 <P>Hello,</P><P>I'm looking to get a crc32 from a csv file or a sql table whatever (example: 2 columns and 2 rows).</P><P>with the tAddCRCRow I manage to get the CRC of each line but not of the complete file (see images).</P><P>How can I proceed to have a single CRC and not one per row ?</P><P>I was thinking of storing the whole file in a buffer to transform it into a single column and a single row (like a concatenation) but I don't know how to do this</P><P></P><P></P><P>Thank you for your help.</P><P></P><P></P><P>csv file exemple :</P><P></P><P></P><P>colonne1; colonne2</P><P>100; 200</P><P>150; 350</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Ibwz3AAB.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143507iC1011B29DE6ADF2A/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000Ibwz3AAB.jpg" alt="0695b00000Ibwz3AAB.jpg" /></span></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000IbwzDAAR.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129756iB0B8A6698363F297/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000IbwzDAAR.jpg" alt="0695b00000IbwzDAAR.jpg" /></span></P><P></P><P></P> Fri, 15 Nov 2024 23:47:15 GMT https://community.qlik.com/t5/Talend-Studio/Talend-TOS-CRC-tAddCRCRow/m-p/2364072#M127870 obenabed 2024-11-15T23:47:15Z https://community.qlik.com/t5/Talend-Studio/Talend-TOS-CRC-tAddCRCRow/m-p/2364073#M127871 <P>Hi</P><P>You can use tFileInputRaw to read the whole file as a string.</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Fri, 17 Sep 2021 07:21:23 GMT https://community.qlik.com/t5/Talend-Studio/Talend-TOS-CRC-tAddCRCRow/m-p/2364073#M127871 Anonymous 2021-09-17T07:21:23Z