Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to read input excel file with repeated headers

jesemmvilla
5 - Atom

Hi, 

 

I need your support on this question, as I'm not sure how to handle it. I have an excel file that contains several headers in the same sheet, this is because is separated by company, bank and contract. 

 

My idea is to transpose those fields into the lines as an aditional column. 

 

I'm attaching the excel file but the main idea is this:

 

Original format:

Bank: Bank Name 1

    
Company: Company Name 1     
Currency 1    
DateIncomeOutcomeCurrent BalanceTaxes
01/01/2019100109030
01/02/201950050550150
01/03/201910010020060

Bank: Bank Name 2

    
Company: Company Name 2     
Currency     
DateIncomeOutcomeCurrent BalanceTaxes
01/01/2019100109030
01/02/201950050550150
01/03/201910010020060

 

 

Desired format:

Bank

CompanyCurrencyDateIncomeOutcomeCurrent BalanceTaxes
Bank Name1Company1Currency101/01/2019100109030
Bank Name1Company1Currency101/02/201950050550150
Bank Name1Company1Currency101/03/201910010020060
Bank Name2Company2Currency201/01/2019100109030
Bank Name2Company2Currency201/02/201950050550150
Bank Name2Company2Currency201/03/2019100100200

60

 

Thanks in advance.

 

Emmanuel Villanueva

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

You can use a multirow formula to "drag down" the headers until they change and then filter out the headers. See attached for an example. 

 

echuong1_0-1575908500210.png

jesemmvilla
5 - Atom

I appreciate the quick reply, this helps me to start working on the data, there is some additional step that I missed before, there's a contract number on each header, that this is the unique value for each bucket of headers/lines. 

 

How can I do the multirow formula with this? if the contract number is different on each row?

 

Thanks!

Labels