nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Make one column of data into one quoted, comma separated field

Archaeopteryx

Hi,

I'm running an API where I provide UserIDs as quoted, comma separated values. Like this:

{"userIds":["12345-67890-54321-54321","67583-02751-22331-54545","21234-00900-44567-13135","...",",,,",".."]}, and on and on.

The API in question generates a User Status Detail Report, which is a canned report within the Admin Portal that carries its own ID.

First I run a stored procedure to fetch all the users from the database table. I then "Select" the UserID column all by itself. Now for the tough part - and you guys may be able to show me a better way, but ...

I would like to take that UserID column, and make it into one field whos IDs are quoted and comma separated. I would pass that field into an Alteryx formula that is the payload API for the Download tool.

Is this possible? Thank you for any assistance.

Chris

API

Accepted answers

atcodedog05

Hi @Archaeopteryx

Configure like below.

Hope this helps : )

user id.yxmd

All comments

atcodedog05

Hi @Archaeopteryx

Here is how you can do it.

Workflow:

1. Using formula to add separator and keep only the required string.

2. Using text to columns to split to rows.

Hope this helps : )

user id.yxmd

apathetichell

the user-ids come into the database table like "12345-67890-54321-54321" or with no quotes? with quotes you'd use a summarize tool set to concatenate your user id: