Multiple Header Rows need to columns.

knamc_com

I am back to Alteryx after a (12 month) reprieve and trying to get back into it. I have a file with multiple headers that I need to make into columns.  I need some help.  Below is the data structure: Breaks on Each account number.  See the attached example of data.

Thank you

Book1.xlsx

rzdodson

@knamc_com there are a couple of different approaches you can take here:

Option 1: Use the "Start Data Import on Line" option in your input tool

Click on your Input tool to bring up its Configuration settings. It'll be the seventh option down. By default, Alteryx starts its data import from Line 1. For your use case, I would change this to "2". This will basically shift your entire data input up by one row so that "Employee Name       Identifier Work Order"," Description", etc. are in the header row. From there, you can drop a Sample tool and change the options to "Skip 1st N Rows" and change the N value to "1". This will get rid of the records that have the hyphenated placeholder in them ("----------"). The end result will produce the table's data, plus your total row that you have in the file.

Option 2: Use Dynamic Rename from the Developer palette

This tool has a "Take Names from First Row Option" as a part of its configuration settings. Keep in mind this route will require you to have that Employee Name/Description/Type records in the first row of data to get it to work. After implementing, you'll have the same type of output I think you are looking for.

Hopefully this helps you get closer to a solution for you.