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?
Solved! Go to Solution.
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 🙂
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.
@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
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 : )
Hi @Feras95p
Here is the regex formula.
REGEX_Replace([Name], "(\u+)[_\d]*", "$1")
Workflow:
Hope this helps : )
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