topic Find length of each string row by row in Data Quality

topic Find length of each string row by row in Data Quality https://community.qlik.com/t5/Data-Quality/Find-length-of-each-string-row-by-row/m-p/2206167#M870 <P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Hvc2vAAB.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143686i1F0A08916165B4A7/image-size/large?v=v2&px=999" role="button" title="0695b00000Hvc2vAAB.jpg" alt="0695b00000Hvc2vAAB.jpg" /></span></P><P>How can i get the count of each string. Below is the output</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Hvc3jAAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153618i6BC5696FD5AE853E/image-size/large?v=v2&px=999" role="button" title="0695b00000Hvc3jAAB.png" alt="0695b00000Hvc3jAAB.png" /></span></P> Fri, 15 Nov 2024 23:47:37 GMT Darmesh 2024-11-15T23:47:37Z Find length of each string row by row https://community.qlik.com/t5/Data-Quality/Find-length-of-each-string-row-by-row/m-p/2206167#M870 <P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Hvc2vAAB.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143686i1F0A08916165B4A7/image-size/large?v=v2&px=999" role="button" title="0695b00000Hvc2vAAB.jpg" alt="0695b00000Hvc2vAAB.jpg" /></span></P><P>How can i get the count of each string. Below is the output</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Hvc3jAAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153618i6BC5696FD5AE853E/image-size/large?v=v2&px=999" role="button" title="0695b00000Hvc3jAAB.png" alt="0695b00000Hvc3jAAB.png" /></span></P> Fri, 15 Nov 2024 23:47:37 GMT https://community.qlik.com/t5/Data-Quality/Find-length-of-each-string-row-by-row/m-p/2206167#M870 Darmesh 2024-11-15T23:47:37Z Re: Find length of each string row by row https://community.qlik.com/t5/Data-Quality/Find-length-of-each-string-row-by-row/m-p/2206168#M871 <P>Hi </P><P>Add a new column in the output table tMap, and set its expression as:</P><P>row1.Column1.length()</P><P> </P><P>//call the Java function to get the length of a string. </P><P> </P><P>Regards</P><P>Shong</P> Wed, 01 Sep 2021 02:47:26 GMT https://community.qlik.com/t5/Data-Quality/Find-length-of-each-string-row-by-row/m-p/2206168#M871 Anonymous 2021-09-01T02:47:26Z