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

Remove columns without header

vijaylnyadav
8 - Asteroid

hi,

 

Consider the following data,

 

12 3 5
AB C D
EF 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" - 

vijaylnyadav_1-1613639935891.png

 

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

 

vijaylnyadav_0-1613639894592.png

 

8 REPLIES 8
afv2688
16 - Nebula
16 - Nebula

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:

 

Untitled.png

 

Regards

vijaylnyadav
8 - Asteroid

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...

vijaylnyadav_0-1613640436675.png

 

Qiu
20 - Arcturus
20 - Arcturus

@vijaylnyadav 

If you are looking for a more dynamic way.

0218-vijaylnyadav.PNG

vijaylnyadav
8 - Asteroid

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

Emil_Kos
17 - Castor
17 - Castor

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
16 - Nebula
16 - Nebula

Hello @vijaylnyadav ,

 

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

 

Regards

vijaylnyadav
8 - Asteroid

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

 

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

 

Qiu
20 - Arcturus
20 - Arcturus

@vijaylnyadav 

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

0218-vijaylnyadav-1.PNG

Labels