IMPORTJSONAPI icon indicating copy to clipboard operation
IMPORTJSONAPI copied to clipboard

concatenate multiple array matches in a single cell

Open pbazerque opened this issue 5 years ago • 1 comments

Hi, thx a lot for the function, works great !

I d like to be able to display a concatenated list in a single cell .

I have a feed with arrays of tags for each item, and I would like to concatenate all item tags in a single column

For example, I would target each item, and use columns: tags[].slug, and I would like it to return "gouvernement, remaniement,..."

Currently I can only think of creating multiple columns tags[0].slug,tags[1].slug,... and concatenate them in Sheet, but that relies on knowing the maximum number of tags

"tags": [
               {
           "slug": "gouvernement",
           "nodeId": "null"
       }
       ,                {
           "slug": "remaniement",
           "nodeId": "null"
       }
       ,                {
           "slug": "ministre-de-l-interieur",
           "nodeId": "null"
       }
       ,                {
           "slug": "tensions",
           "nodeId": "null"
       }
                   ], 

pbazerque avatar Nov 27 '20 12:11 pbazerque

+1

dgillier avatar Jul 09 '23 11:07 dgillier