Remove columns without header

[vijaylnyadav]

hi,

Consider the following data,

1	2		3		5
A	B		C		D
E	F		G		H

Condition:- 

I want to remove the column that have no headers.

When i load this excel file in Alteryx then it is automatically rename the columns that have no header with "F***".

Please suggest some workflow.

Excel File" - 

When i load this in alteryx then i am getting this result

[afv2688]

Hello @vijaylnyadav ,

You can do this with a dynamic selection tool. By establishing a rule or condition on the name with a formula you are able to dynamically select which ones you want:

Regards

[vijaylnyadav]

Hi @afv2688,

I have a large set of data which have many columns that is with empty headers and while loading in alteryx it is taking much longer time to load and when i implement your solution than it is not working.

I have a dirty excel file in which i have around 400 rows and more than 1000 column in which around 56 columns are names and rest are not names.

Please suggest some workflow

Please refer the below image as the columns without header it is renaming as F50 and so on...

[Qiu]

@vijaylnyadav 

If you are looking for a more dynamic way.

[vijaylnyadav]

Hi @Qiu please refer the snapshots attached in chats and suggest some workflow.

[Emil_Kos]

Hi @vijaylnyadav,

In that case, I would suggest having one workflow that will remove unnecessary columns and it will save it as a clean yxdb file. 

I am not sure if you can load only the data with proper column headers in Alteryx. 

[afv2688]

Hello @vijaylnyadav ,

if those are the names of the columns you can also change the formula

Regards

[vijaylnyadav]

Hi @Qiu after implementing your workflow in actual data the columns names are changed.

the spaces between the column names are replaced by '_'.

[Qiu · Accepted solution]

@vijaylnyadav 

You are correct, we need a dynamic Rename tool for that.