Hi All,
I have never used my row as header. I tried using Transpose, but failed.
Below is my input which I want to use my as Header. In my output I have 3 columns with month name.
Appreciate your help:)
Hi @DiyaR
Here is how you can do it. I am using dynamic rename find & replace column name method.
Workflow:
1. Using field info tool i am getting info of Price & >1k Yes/No.
2. Using summarize i am getting month value.
3. Using append i am joining field name and month.
4. Using formula i generating new column names.
5. Using dynamic rename tool i am configuring it to rename old names with new names from the R anchor.
Hope this helps 🙂
Have you tried the dynamic rename tool? You can take your first row of data and set it to the header values.
https://help.alteryx.com/current/designer/dynamic-rename-tool
You can also specify what row to start data import from in your Input Data tool. This is probably the easiest approach for what you are looking to do.
Can you provide above data in excel.
Hi,
Attached, in spreadsheet, two sperate tabs. thank you
@Brandon B - I know you can choose a row to start on other than the first row when you use the normal input tool but can you do the same if you use the google sheets input tool and if so how as I want to do this but can't see the functionality when using the google input tool
@BrandonB Thx so much! I am new to alteryx and reached out to you as on searching for other solutions a lot of your responses helped me! Much appreciated
Attached is my solution
Hello, I've had the same issue to fix today and for me all of the possible solutions that I've found are way to complicated for a simple thing. I think we all agree on that.
The solution that I've is noticing that Alteryx identifies all as rows even the column names.So all you need to do is change from which row you wanna start importing in the Input data!!! The 7th option of the input tool!
