How to convert first column data as header or excel like 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
Hi
I wish to transpose my data like excel.I have the following data:
Month | Jan | Feb | Mar | Apr | May |
Field1 | 8,903.77 | 4,383.79 | 7,036.86 | 2,456.41 | 1,835.62 |
field2 | 809.50 | 1,357.49 | 5,756.23 | 7,937.68 | 4,464.97 |
Field3 | 5,846.71 | 126.28 | 2,674.24 | 9,757.16 | 1,998.16 |
Field4 | 5,505.00 | 5,132.69 | 5,348.57 | 5,651.72 | 3,037.45 |
And I want output as:
Month | Field1 | field2 | Field3 | Field4 |
Jan | 8903.77 | 809.4979 | 5846.706 | 5504.997 |
Feb | 4383.787 | 1357.492 | 126.2758 | 5132.688 |
Mar | 7036.86 | 5756.234 | 2674.237 | 5348.572 |
Apr | 2456.41 | 7937.68 | 9757.158 | 5651.724 |
May | 1835.619 | 4464.965 | 1998.164 | 3037.447 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Joseph,
thanks for swift reply.. really appreciate it... I have a small query here.. Have you converted numbers to string? As data type for all months appears to be string.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I can not change the datatype of the columns so the concatenation function can not be performed on values at crosstab level. Please advise
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sakshim I amended the workflow however your example data has , in the data so that would mean that data would be read as a string in Alteryx. In my workflow I have amended workflow I have removed the , and converted the data into a numeric data type.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Many thanks Joseph... this is working for me perfectly now. Now, this makes me little curious to understand the use of data cleansing tool here.
