Extra columns in Output

Question

Hello, I am having trouble getting rid of extra columns in my output file. In the browse tool it doesn't show any extra columns but when I export it as a CSV file there are extra columns that read Column 1, Column 2, Column 3, etc. Has anyone else dealt with this issue before and is there a way to fix it? See screenshots below.

Alteryx_Columns_issue.JPG

Alteryx_columns_issue_Excel.JPG

Sjkitts · Answer

I've been exporting it and saving it as a CSV and in the CSV I have to put it into table format which i believe adds the columns to the CVS. Kind of seems its not an Alteryx issue....In this situation I have to export it as a CSV and put it in table format.

Christine_Assaad · Answer

Hi @Sjkitts

Are you writing your output to an Excel table? Are you configuring your output to preserve format and write to specific range?

It may be good if you can send a screenshot of your output tool configuration. Thanks!

IraWatt · Answer

Hey @Sjkitts,

Could you provide an example CSV or workflow? CSV's don't have formatting, did you add that after you opened the CSV? Can you show a screenshot of your output data tool configuration?

Thanks,

Ira