Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Formatting output data in a CSV

averyn
6 - Meteoroid

The output file type is a CSV(needs to be in a CSV)

I need the first column to consist of 7 numbers

and the second row of data in the F column

 

What tools can I use to make this happen in my workflow?

 

See pictures for a visual

 

Thanks so much for the help!1.PNG     2.PNG

2 REPLIES 2
JohnJPS
15 - Aurora

Could you use a Formula Tool to create some dummy columns (String type with empty string for value ""), then Select Tool to get the proper column ordering?

RodL
Alteryx Alumni (Retired)

@JohnJPS's suggestion is where I would go as well. Confirmed it works.

Plus to get the leading zeros in your first column, use the PadLeft function. (To do this, you will need to convert the first column to a string data type.)

Labels