This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to take output from a cross tab that produces columnar data and use it as the input to build post body to be sent to an API. For instance, I want to flatten all of my IDs into a comma separated string (API takes an Array) and then make one call.
Assuming you have a column in your data with the IDs (let's assume it's called 'ID Field') you could use a Multi-Row formula tool to create a new string field that appends each ID to the previous with a comma. You then grab this new field in the last row of data and you have your array of IDs.
If you name this new field 'ID for API', the formula would look like: Row -1 [ID for API]+','+Current Row [ID Field]