topic Re: concat works randomly in App Development https://community.qlik.com/t5/App-Development/concat-works-randomly/m-p/2515986#M105736 <P>thanks! I apologize... one should read the help files&nbsp;</P><P>&nbsp;</P><DIV><!-- Layout, Style or Voice Helpers --><DIV class="">&nbsp;</DIV><!-- Compliance --><DIV class=""><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --><DIV>Opens in new window</DIV><DIV>PDF Download</DIV><DIV>Word Download</DIV><DIV>Excel Download</DIV><DIV>PowerPoint Download</DIV><DIV>Document Download</DIV></DIV><!-- Versioning Control Panel if versioning = true ! --><!-- Launcher --><!-- Toolbar --><!-- Site Menu --><!-- Generic Aria Live message container --><DIV class="">&nbsp;</DIV><!-- Symbol definitions --></DIV><!-- end #ae_app --> Mon, 28 Apr 2025 10:18:57 GMT draghici1109 2025-04-28T10:18:57Z concat works randomly https://community.qlik.com/t5/App-Development/concat-works-randomly/m-p/2515921#M105731 <P>Hello,</P><P>I have to concatenate several records in one field using the concat() function. Yet concat works somehow randomly and concatenate the records not sorted but randomly. Here is the code:</P><DIV>prepTLINE:</DIV><DIV>NoConcatenate</DIV><DIV>LOAD</DIV><DIV>&nbsp; &nbsp; TABNR,</DIV><DIV>&nbsp; &nbsp; num#(SubField(TABSEQNR, '0', -1)) AS NumTABSEQNR,</DIV><DIV><SPAN>TLINE</SPAN></DIV><DIV>FROM HRT1002.qvd] (qvd);</DIV><DIV>&nbsp;</DIV><DIV><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="draghici1109_0-1745824446807.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179959iB4005E98AE9E06D5/image-size/medium?v=v2&amp;px=400" role="button" title="draghici1109_0-1745824446807.png" alt="draghici1109_0-1745824446807.png" /></span><P>&nbsp;</P></DIV><DIV>&nbsp;</DIV><DIV>prepMappingTLINE:</DIV><DIV>NoConcatenate</DIV><DIV>LOAD</DIV><DIV>&nbsp; &nbsp; TABNR,</DIV><DIV>&nbsp; &nbsp; NumTABSEQNR,</DIV><DIV><SPAN>TLINE</SPAN></DIV><DIV>Resident prepTLINE</DIV><DIV>order BY TABNR,NumTABSEQNR ASC;</DIV><DIV>&nbsp;</DIV><DIV>STORE prepMappingTLINE into prepMappingTLINE.qvd] (qvd);</DIV><DIV>&nbsp;</DIV><DIV>DROP Table prepTLINE;</DIV><DIV>&nbsp;</DIV><DIV>// Step 3: Create mapping table using sorted QVD</DIV><DIV>SortedTLINE:</DIV><DIV>NoConcatenate</DIV><DIV>LOAD</DIV><DIV>&nbsp; &nbsp; TABNR,</DIV><DIV>&nbsp; &nbsp; NumTABSEQNR AS TABSEQNR,</DIV><DIV>&nbsp; &nbsp; TLINE</DIV><DIV>Resident prepMappingTLINE</DIV><DIV>ORDER BY TABNR, NumTABSEQNR;</DIV><DIV>&nbsp;</DIV><DIV>mTLINE:</DIV><DIV>Mapping</DIV><DIV>LOAD</DIV><DIV>&nbsp; &nbsp; TABNR,</DIV><DIV><SPAN>Concat(TLINE, ' ') AS AllTLINE</SPAN></DIV><DIV>RESIDENT SortedTLINE</DIV><DIV>GROUP BY TABNR;</DIV><DIV>&nbsp;</DIV><DIV>----</DIV><DIV>Here is the end result:&nbsp;</DIV><DIV>&nbsp;</DIV><DIV><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="draghici1109_1-1745824502532.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/179960i8BA392261108C25F/image-size/medium?v=v2&amp;px=400" role="button" title="draghici1109_1-1745824502532.png" alt="draghici1109_1-1745824502532.png" /></span></DIV><!-- end #ae_app --><P>&nbsp;</P><DIV><!-- Layout, Style or Voice Helpers --><DIV class="">&nbsp;</DIV><!-- Compliance --><DIV class=""><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --><DIV>Opens in new window</DIV><DIV>PDF Download</DIV><DIV>Word Download</DIV><DIV>Excel Download</DIV><DIV>PowerPoint Download</DIV><DIV>Document Download</DIV></DIV><!-- Versioning Control Panel if versioning = true ! --><!-- Launcher --><!-- Toolbar --><!-- Site Menu --><!-- Generic Aria Live message container --><DIV class="">&nbsp;</DIV><!-- Symbol definitions --></DIV><!-- end #ae_app --><P>&nbsp;</P><DIV><!-- Layout, Style or Voice Helpers --><DIV class="">&nbsp;</DIV><!-- Compliance --><DIV class=""><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --><DIV>Opens in new window</DIV><DIV>PDF Download</DIV><DIV>Word Download</DIV><DIV>Excel Download</DIV><DIV>PowerPoint Download</DIV><DIV>Document Download</DIV></DIV><!-- Versioning Control Panel if versioning = true ! --><!-- Launcher --><!-- Toolbar --><!-- Site Menu --><!-- Generic Aria Live message container --><DIV class="">&nbsp;</DIV><!-- Symbol definitions --></DIV><!-- end #ae_app --> Mon, 28 Apr 2025 07:21:52 GMT https://community.qlik.com/t5/App-Development/concat-works-randomly/m-p/2515921#M105731 draghici1109 2025-04-28T07:21:52Z Re: concat works randomly https://community.qlik.com/t5/App-Development/concat-works-randomly/m-p/2515974#M105735 <P>You need only to specify the third (numeric) parameter of:</P><P>concat(Field/Expression, Delimiter, <STRONG>Sort</STRONG>)</P><DIV><DIV class="">&nbsp;</DIV><!-- Symbol definitions --></DIV><!-- end #ae_app --> Mon, 28 Apr 2025 09:36:23 GMT https://community.qlik.com/t5/App-Development/concat-works-randomly/m-p/2515974#M105735 marcus_sommer 2025-04-28T09:36:23Z Re: concat works randomly https://community.qlik.com/t5/App-Development/concat-works-randomly/m-p/2515986#M105736 <P>thanks! I apologize... one should read the help files&nbsp;</P><P>&nbsp;</P><DIV><!-- Layout, Style or Voice Helpers --><DIV class="">&nbsp;</DIV><!-- Compliance --><DIV class=""><!-- For autoSmartRem addNewWindowWarnings div is referenced in an aria-describedby --><DIV>Opens in new window</DIV><DIV>PDF Download</DIV><DIV>Word Download</DIV><DIV>Excel Download</DIV><DIV>PowerPoint Download</DIV><DIV>Document Download</DIV></DIV><!-- Versioning Control Panel if versioning = true ! --><!-- Launcher --><!-- Toolbar --><!-- Site Menu --><!-- Generic Aria Live message container --><DIV class="">&nbsp;</DIV><!-- Symbol definitions --></DIV><!-- end #ae_app --> Mon, 28 Apr 2025 10:18:57 GMT https://community.qlik.com/t5/App-Development/concat-works-randomly/m-p/2515986#M105736 draghici1109 2025-04-28T10:18:57Z