Blank Header column

[yewteck]

Is it possible to create a blank header column with the output file format as .csv?

i have searched in the community discussion and saw suggestions using Render Tool but Render Tool will not support csv format.

[Sebastian_Chaieb2]

Hi @yewteck 

If you just need to create an output (CSV) without headers you can configure Output Data tool like below:

 

In other case, if you need an output with blank first row (without header names - like below), please check my solution:

 The idea is described in tool annotations.

Thanks,

Sebastian 

[yewteck]

Hi @sebastian_chaieb2,

Thanks for the solution. I think i am not clear on my initial query.

I am trying to find out solution where (if using the example you created) Column A header is blank and the remaining columns having subject headers.

[binuacs · Accepted solution]

@yewteck Have you tried using put a blank space in the Colum A header 

[martinson · Accepted solution]

Hi @yewteck. I don't believe it is possible to have a blank header column. However, it is possible to have a header column with a black space. Using the dynamic rename tool and setting the top line to a space or renaming the column with a space (or multiple spaces) in the select tool should get this to work.

Let me know if you have any other questions!

martinson

Bulien

Column 1 here is named " " and column 2 is named "  "

[Sebastian_Chaieb2 · Accepted solution]

The question is were you want to see Blank (empty) headers? when you open CSV in Excel, Notepad or as another input in Alteryx?

As designing that Column A is empty and the rest is as it should be (or renamed) is not a problem using many options (read data where first row contains data then change desired column headers to "" empty string and then use dynamic rename (remember that Alteryx will not allow you to keep two or more the same headers). 

Adjusting solution you can see it like this:

 

 

 In Excel:

In notepad:

 

 

[yewteck]

Thanks for the solutions above, the space works!