Headings on different rows

[ianody]

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.

[messi007]

@ianody,

Please see bleow:

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

Attached the workflow,

Hope that helps!

Regards,

[FlorianC · Accepted solution]

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.

Workflow

[ianody]

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

Regards

Ian