community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Specifying the column headings

Atom

Hi,

 

I am trying to delete specific rows from my raw data, but I am getting an extra row prior to my heading and I don't even have those in my original data. Thus when I added a new column, its column heading is not aligned with the other column headings.

I have used either Select Record Tool, setting the range to 10+ (for example), and the Sample Tool Skipping the first 9 rows. But I am getting the same results for both. I have attached the screen shot of my raw data, the desired output and the actual result I'm getting (all headings only). Any idea please? Thanks in advance!

Alteryx Certified Partner
Alteryx Certified Partner

I've attached an example workflow.

 

After you perform the select records you also need to use the 'dynamic rename' to make your first row your headers.

 

Ben

Alteryx Partner

Before you add the "Business" column, and after your Select Record Tool, try adding a Dynamic Rename tool and choose the "Rename Mode": "Take Field Names from First Row of Data".

 

This should make it so that your headers are now the true column names, and so when you create the new "Business" column, things will line up correctly.

 

Let me know if this helps,

 

Cheers!

Atom

Thanks so much Ben. It worked!

Atom

Thank you tcroberts! I know it is a very basic question, but I got stuck for a couple of days searching for the solution. I am so relieved with you and other guys' help.

Labels