Naming the columns

Dear all,

I'm facing a problem with naming the column, I have named the column from 1 to 5 the first five column and again the next five I named them from 1 to 5 but when I insert the excel sheet as an input to my workflow it became as shown in the picture attached below. 1_2 ... How can I make it 1 to 5 for all?

Workflow

Input

Help

Udacity

Accepted answers

atcodedog05

Hi @Feras95p

Here is the regex formula.

REGEX_Replace([Name], "(\u+)[_\d]*", "$1")

Workflow:

Hope this helps : )

weekday names.yxmd

danilang

Hi @Feras95p

While it's true that the field names in Alteryx have to be unique, this doesn't mean that can't you read the values anyway. You just have to ensure that the Day Numbers aren't used as field names.

To use the Excel column number as the column name, check "First Row Contains Data" in your Input Data tool

With this checked, your first row from your excel file becomes the first row of your data. You then completely transpose the data using a transpose/crosstab combo to give you this.

From here you can apply summary operations with Day_Number as the Group By field

Dan

RepeatingColumnNames.yxzp

All comments

atcodedog05

Hi @Feras95p

In data tables all column names should be unique so that they can used in calculations. Having multiple columns with same name with create conflict in referencing hence they are renamed.

If you can provide more info on why you need column names in this way. We can help you out 🙂

dhavaldoshi

Hi @Feras95p ,

This is usually a common issue with Alteryx, it a field based tool, i.e. all operations are done on column names. So it wouldn't exactly make sense if there were multiple columns with same name as you couldn't perform any functions on the same.

Feras95p

@dhavaldoshi @atcodedog05 Thanks for replying.

The problem is that I want to name the columns from Sunday to Thursday for almost 5 months then I want to know some data for all Sunday and the same of each day. But when I used summarize tool to group by all Sundays for the period of 5 months it gives Sunday 1 Sunday 2 .... but I want only Sunday

atcodedog05

Hi @Feras95p

Can you share a sample file with headers.

atcodedog05

Hi @Feras95p

You can regex formula like below to normalize the weekdays. And you can use this column for groupby.

REGEX_Replace([Field1], "(\u+)\d*", "$1")

Workflow:

Hope this helps : )

weekday names.yxmd

danilang

Hi @Feras95p

While it's true that the field names in Alteryx have to be unique, this doesn't mean that can't you read the values anyway. You just have to ensure that the Day Numbers aren't used as field names.

To use the Excel column number as the column name, check "First Row Contains Data" in your Input Data tool

With this checked, your first row from your excel file becomes the first row of your data. You then completely transpose the data using a transpose/crosstab combo to give you this.

From here you can apply summary operations with Day_Number as the Group By field

Dan

RepeatingColumnNames.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703