Combine xlsx and csv into one file

[ppatane]

I have a workflow that I need to output as an xlsx file and then as a pipe delimited csv, and then either add the single csv column to the end of the xlsx file, or make it sheet2 in the same file.  Using the Block Until Done tool I can get the 2 files outputted the way I want, but I don't know how to combine them in one of the ways I described..

Also, the csv portion would need the rows to end in a pipe, so the blank column is there, and I can manually remove the Col 6 heading after output

 

[geraldo · Accepted solution]

@ppatane 

An workflow example

[ppatane]

Thanks for the workflow! Though not exactly what I ended up doing, a number of things you did helped me to complete mine.  Grazie!

Update...I ended up using a lot more of your workflow than I started out doing.  Great job...thanks again!

[lbardoe]

You could use the add a Row Column to the data then transpose Rows to Columns tool to give you one column with all the values then use the Columns to Rows tool to concatenate the data using the | as the delimiter then append the 2 data sets together using the Row Column as the Join ID.