Remove columns without header

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

Datasets

Accepted answers

Qiu

@vijaylnyadav

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

0218-vijaylnyadav-1.yxzp

All comments

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

dynamic select.yxmd

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.