Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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