Transpose
- 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
Input looks like:-
Please note that all the figures and headings can change, also the number of columns can increase or decrease.
Required Output:-
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's an example of how you can get this to work:
- Isolate the multiple header rows (first 3 rows) and transpose/crosstab to get a table of Entity ID, Entity Name, and Currency
- Read in the rest of the data and use the dynamic rename to promote the entity IDs to the headers, then transpose
- Join up the data from the first two steps on the entity IDs, and rename the fields.
This should get you going in the right direction, but let me know if you have any issues.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Luke_C
I am really very sorry for the late response.
The solution shared by you is amazing and this is complete in nature. I am really very thankful to you for the help.
Have a great day ahead!!
Thanks & Regards,
Deepak
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help! Please be sure to mark the solution on my reply so others can find it easier.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI @Luke_C
I am facing another issue relating to alteryx.
Actually when I am using render tool to generate a report then the excel file generated contains data in number format. Can we convert it to string value.
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What is the data type in Alteryx? If it's numeric try using a select tool to convert it to a string. Otherwise it may be excel trying to be smart and default it to be numeric.
As a side note, please be sure to accept the earlier solution :).
