SOLVED
Rearrange data set
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
Jack0091
7 - Meteor
‎09-13-2023
12:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello I have the following data set
FROM_DATE | TO_DATE | FROM | TO | PRICE |
2023-01-01 | 2023-01-31 | 1 | 160 | .345 |
2023-01-01 | 2023-01-31 | 161 | 250 | .234 |
2023-01-01 | 2023-01-31 | 251 | 400 | .646 |
2023-01-01 | 2023-01-31 | 401 | 600 | .423 |
2023-01-01 | 2023-01-31 | 601 | 9999 | .874 |
2022-08-15 | 2022-12-31 | 1 | 160 | .765 |
2022-08-15 | 2022-12-31 | 161 | 250 | .324 |
2022-08-15 | 2022-12-31 | 251 | 400 | .545 |
2022-08-15 | 2022-12-31 | 401 | 600 | .762 |
2022-08-15 | 2022-12-31 | 601 | 9999 | .927 |
I would like to rearrange it to look like this
FROM_DATE | TO_DATE | 1 | 160 | 250 | 400 | 600 |
2023-01-01 | 2023-01-31 | .345 | .234 | .646 | .423 | .874 |
2022-08-15 | 2022-12-31 | .765 | .324 | .545 | 762 | .927 |
Solved! Go to Solution.
2 REPLIES 2
16 - Nebula
‎09-13-2023
01:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Jack0091
Simply you can just use Cross Tab tool. Please refer to the attached workflow. If you have further query, please let me know.
‎09-13-2023
02:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you it works !
