Headings on different rows

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.

Screenshot 2021-01-04 121831.png

Datasets

Accepted answers

This requires indeed a bit of parsing:

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

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

Workflow

Headings on different rows.yxmd

All comments

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,

UpdateHeaders.yxmd

This requires indeed a bit of parsing:

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

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

Workflow

Headings on different rows.yxmd

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

Regards

Ian

Quick Links

Tags

This months top contributors

AkimasaKajitani 390

michael_weaver 335