https://community.qlik.com/t5/Qlik-Automate/loop-through-list-of-JSON-and-get-back-comma-separated-values/m-p/2111458#M2403 <P>I kept trying and found one solution:</P> <P>I have added a loop where I introduced a new variable for which proper value could be appended in each iteration step - and finally I had to simply select this new variable in the output</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_0-1693405919775.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115410iA1C135DAC6DA7820/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_0-1693405919775.png" alt="levente81_0-1693405919775.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_1-1693405950044.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115411i8B1FC94416DF72A2/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_1-1693405950044.png" alt="levente81_1-1693405950044.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_2-1693405965669.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115412i5057B2945ED90A7D/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_2-1693405965669.png" alt="levente81_2-1693405965669.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 30 Aug 2023 14:33:44 GMT levente81 2023-08-30T14:33:44Z https://community.qlik.com/t5/Qlik-Automate/loop-through-list-of-JSON-and-get-back-comma-separated-values/m-p/2111378#M2402 <P>Hi,</P> <P>Could you please advise how can I alter list of single values to list of comma separated / concatenated values?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_0-1693398813681.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115379i917425ABF43F6872/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_0-1693398813681.png" alt="levente81_0-1693398813681.png" /></span></P> <P>Output (that is working properly) now is:</P> <P>- app name that was found by first part of the automation</P> <P>- app id</P> <P>- list of reload start times (<FONT color="#808080"><EM>!ONLY 1 "field" from JSON - working with any&nbsp; single field...</EM></FONT>) regarding that specific app.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_5-1693399517693.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115384iE74B23D98E87021F/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_5-1693399517693.png" alt="levente81_5-1693399517693.png" /></span></P> <P>&nbsp;</P> <P>What I would like to achieve is a list of&nbsp; &nbsp;<STRONG>&lt; start times <FONT color="#0000FF">!!!AND status!!!</FONT> &gt;, </STRONG><FONT color="#FF0000">but I could only get error messages, or unusable response...</FONT></P> <P>&nbsp;</P> <P><FONT color="#FF0000"><EM><STRONG>This was my last try </STRONG></EM></FONT></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_4-1693399477272.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115383i4F0706D0031CF9C6/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_4-1693399477272.png" alt="levente81_4-1693399477272.png" /></span></P> <P>that gives back:&nbsp; "<SPAN>Array &amp; Array"</SPAN></P> <P>Does anyone know what shall be done to correct it?</P> Wed, 30 Aug 2023 12:51:48 GMT https://community.qlik.com/t5/Qlik-Automate/loop-through-list-of-JSON-and-get-back-comma-separated-values/m-p/2111378#M2402 levente81 2023-08-30T12:51:48Z https://community.qlik.com/t5/Qlik-Automate/loop-through-list-of-JSON-and-get-back-comma-separated-values/m-p/2111458#M2403 <P>I kept trying and found one solution:</P> <P>I have added a loop where I introduced a new variable for which proper value could be appended in each iteration step - and finally I had to simply select this new variable in the output</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_0-1693405919775.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115410iA1C135DAC6DA7820/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_0-1693405919775.png" alt="levente81_0-1693405919775.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_1-1693405950044.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115411i8B1FC94416DF72A2/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_1-1693405950044.png" alt="levente81_1-1693405950044.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="levente81_2-1693405965669.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115412i5057B2945ED90A7D/image-size/medium?v=v2&amp;px=400" role="button" title="levente81_2-1693405965669.png" alt="levente81_2-1693405965669.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 30 Aug 2023 14:33:44 GMT https://community.qlik.com/t5/Qlik-Automate/loop-through-list-of-JSON-and-get-back-comma-separated-values/m-p/2111458#M2403 levente81 2023-08-30T14:33:44Z