Transpose Multiple Columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
chc10
7 - Meteor
‎11-19-2020
07:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I'm trying to pull apart some data from multiple columns and transpose it to rows.
As Is
DATE | CATEGORY | PURCHASE_VOLUME_4W | PURCHASE_VOLUME_12W | PURCHASE_VOLUME_52W | PURCHASE_VALUE_4W | PURCHASE_VALUE_12W | PURCHASE_VALUE_52W |
11/20/2020 | COLOGNE | 15142 | 34161 | 174355 | 111730 | 242573 | 1264613 |
11/20/2020 | COLOGNE | 10387 | 37116 | 249886 | 73596 | 262819 | 1764439 |
To Be
DATE | CATEGORY | PERIOD_GROUP | PURCHASE_VOLUME | PURCHASE_VALUE |
11/20/2020 | COLOGNE | 4W | ||
11/20/2020 | COLOGNE | 4W | ||
11/20/2020 | COLOGNE | 12W | ||
11/20/2020 | COLOGNE | 12W | ||
11/20/2020 | COLOGNE | 52W | ||
11/20/2020 | COLOGNE | 52W |
Pls can you help?
Thanks
5 REPLIES 5
21 - Polaris
‎11-19-2020
08:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎11-19-2020
08:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @chc10
I make workflow.
Please refer attached file.
I use the newest Designer version 2020.4.
If you can't open the attached file, you have to update designer or version down the yxmd file(open by text editor and overwrite version info).
14 - Magnetar
‎11-19-2020
08:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @chc10,
This should work for your data set. By using key columns in the Transpose tool and group by data in the Cross Tab you can get the data into the format you are looking for. The RecordID tool at the beginning keeps each line separate for the Cross Tab tool.
DeanWest
9 - Comet
‎11-19-2020
08:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
grazitti_sapna
17 - Castor
‎11-20-2020
01:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
