Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
levente81
Partner - Contributor III
Partner - Contributor III

loop through list of JSON and get back comma separated values for particular "fields"

Hi,

Could you please advise how can I alter list of single values to list of comma separated / concatenated values?

levente81_0-1693398813681.png

Output (that is working properly) now is:

- app name that was found by first part of the automation

- app id

- list of reload start times (!ONLY 1 "field" from JSON - working with any  single field...) regarding that specific app.

levente81_5-1693399517693.png

 

What I would like to achieve is a list of   < start times !!!AND status!!! >, but I could only get error messages, or unusable response...

 

This was my last try

levente81_4-1693399477272.png

that gives back:  "Array & Array"

Does anyone know what shall be done to correct it?

Labels (1)
1 Solution

Accepted Solutions
levente81
Partner - Contributor III
Partner - Contributor III
Author

I kept trying and found one solution:

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

levente81_0-1693405919775.pnglevente81_1-1693405950044.pnglevente81_2-1693405965669.png

 

 

View solution in original post

1 Reply
levente81
Partner - Contributor III
Partner - Contributor III
Author

I kept trying and found one solution:

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

levente81_0-1693405919775.pnglevente81_1-1693405950044.pnglevente81_2-1693405965669.png