Create csv that places data into different columns

Question

Trying to create an output file as a csv that is being transported as a blob to a SFTP server. I need to be able to place three resultant  "rows"  of data -

into an output that will place each of those into separate columns in a csv output, like this below -

Required output

I know this likely involves the Summary tool as a concatenate function with 	 as the delimiter. Trying multiple iterations of this, I'm not getting it to tab into the different columns as desired.

Getting the "List" data into a single row is being done via a Cross Tab with a space as the separator in this sample, but I've tried combos of 	, \0 delimiters to no avail. I think this is close, just need a nudge to get it over the edge!

Thx

Blake · Accepted Answer

Hey @sean_bolte_dup_544 - check out the attached workflow, I think it'll do what you want.

The delimiter is set to a comma but you can change that in box 3 of the output data tool. You'll also want to make sure and uncheck box 4 "First row contains field names"

Good luck, let me know if this helps!