Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Multiple Header Rows need to columns.

knamc_com
7 - Meteor

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

 

 

 

5 REPLIES 5
rzdodson
12 - Quasar

@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. :)

knamc_com
7 - Meteor

I still need the Account Number field which is the First Row and then the report breaks on each account row:  I am not if I have to parse and then join back.....still green on this....:-(

 

rzdodson
12 - Quasar

No worries. This one should be pretty easy to knock out. Just two questions for you:

 

1. Do you have any dummy data files that have multiple records that you can provide? I think that Line 3 is the file you provided (9999-0111...) is the Account Number that we can use as a primary key, but unsure.

2. What do you need the final output to look like? Is it a table that has the data for each record (Account Number, Employee Name, Identifier Work Order, Job, Date, Description, Type, Debit, Credit) so you can potentially create batch reports at the Account Number level, or something else?

knamc_com
7 - Meteor

I have attached the data in my previous reply.  Below is what the output should look like, I appreciate any and all help you can provide :-)

 

Account NumberNameIdentifierWork Order/JobDateDescriptionTypeDebitCredit
9999-0111-010-G9-D444-000-ZZ-41-3-53-0211-211-99JONES, CRISSY S1111-5555WF1234567892/1/2024TestNA475.000.00
9999-0111-010-G9-D444-000-ZZ-41-3-53-0211-211-99SMITH, DANIEL P1111-2222WF1234567892/1/2024TestNA250.000.00
9999-0111-010-G9-D444-000-ZZ-41-3-53-0211-211-99DOE, ANTHONY2222-3333WF1234567892/1/2024TestNA250.000.00
9999-0111-010-G9-D444-000-ZZ-41-3-53-0211-211-99CLARK JR, NORMAN A3333-4444WF1234567892/1/2024TestNA250.000.00
      Total1225.000.00
         
9999-0111-010-G9-D444-000-ZZ-41-3-53-0211-212-00JONES,  JAMES3628-4444WF1234567892/1/2024TestNA1475.000.00
9999-0111-010-G9-D444-000-ZZ-41-3-53-0211-212-00SMITH, JOHN1122-2245WF1234567892/1/2024TestNA500.000.00
9999-0111-010-G9-D444-000-ZZ-41-3-53-0211-212-00DOE, JANE1234-4567WF1234567892/1/2024TestNA325.000.00
9999-0111-010-G9-D444-000-ZZ-41-3-53-0211-212-00CLARK , MARY3789-1234WF1234567892/1/2024TestNA450.0020.00
      Total2750.0020.00
HomesickSurfer
12 - Quasar

Hi @knamc_com 

 

Here goes.

 

Capture.PNG

Labels