In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Headings on different rows

ianody
5 - Atom

I have to routinely work with data sets exported from our financial system and I would like to use Alteryx to do some of the work for me.

 

However, I cannot work out how to get the column headers right as the output data but headers on two different rows - the reason for this is that where the report output is monetary, the report puts a currency marker (GBP, USD etc).  I have attached an example of what I mean.

 

What I would like to do is moving things about so the headings all sit on one row.

 

Can anyone help?  I should add that I am a complete novice to alteryx, having only done some basic training modules.

 

 

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@ianody,

 

Please see bleow:

 

If it's note what you request please share the needed output. It will help to understand 🙂

messi007_0-1609764139987.png

 

 

Attached the workflow,

 

Hope that helps!

 

Regards,

FlorianC
Alteryx
Alteryx

Hi @ianody,

 

This requires indeed a bit of parsing:

  1. Generate a unique identifier for the rows;
  2. Split your table between data and metadata (headers);
  3. Parse and concatenate the headers;
  4. Replace the column names in the table with the newly parsed headers;
  5. Drop the generated row ID field.

 

Please find attached a sample workflow and let me know if you have any question.

 

WorkflowWorkflow

Florian Carrier
Strategic Solution Consultant
Alteryx
ianody
5 - Atom

Thank you both for looking.  I managed to get Florian's solution to work for me.

 

Regards

 

Ian

Labels
Top Solution Authors