Headings on different rows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ianody,
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
Strategic Solution Consultant
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you both for looking. I managed to get Florian's solution to work for me.
Regards
Ian
