Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Create csv that places data into different columns

sean_bolte_dup_544
8 - Asteroid

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 -

 

csv out 1.JPG

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

Required outputRequired output

 

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

 

csv out 3.JPG

 

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 \t, \0 delimiters to no avail. I think this is close, just need a nudge to get it over the edge!

 

Thx

 

2 REPLIES 2
Blake
12 - Quasar

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

 

csvtest.png

 

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! 

sean_bolte_dup_544
8 - Asteroid

@Blake 

 

Yep, that was the nudge. Sometimes you just need that to push you over! So this setup is specific to sending the data as a blob payload, rather than a csv file itself. The little nuance is this, the separate fields all named as "List"  are pushed into the Summarize tool, and named as "File_Blob" -

Nudge1.JPG

 

The 3 items in this case concatenated into the blob with the ',' delimiter. The "File_Blob" is now converted to the payload - 

 

Nudge2.JPG

 

The address for the SFTP server is a dynamic creation that involves the name of the file we are creating -

 

Nudge3.JPG

 

This is Appended together, and could just be Joined by position, since we are dealing with singular snippets -

 

Nudge4.JPG

The Download tool setup with derived csv file name address, which defines where in the SFTP directory path we want the file to land -

 

Nudge5.JPG

 

and the "File_Blob" as the Payload for the Put action to the server -

 

Nudge6.JPG

 

The solution you provided certainly works for the direct csv output, this just tweaks it for the situation I have as the upload method to an SFTP server instead.

 

Thanks much!

 

Labels