how to sort date from oldest to newest for particular number and create blank 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
below is the input file which contains number, date and type
Number | Type | Date |
1234 | received | 9/13/2023 |
1234 | received | 9/13/2023 |
1234 | delivered | 9/13/2023 |
2356 | received | 10/22/2023 |
2356 | received | 5/22/2023 |
2356 | received | 10/22/2023 |
2356 | received | 5/22/2023 |
2356 | delivered | 5/22/2023 |
2356 | delivered | 10/22/2023 |
Output should be like below
Number | Type | Date |
1234 | received | 9/13/2023 |
1234 | received | 9/13/2023 |
1234 | delivered | 9/13/2023 |
2356 | received | 5/22/2023 |
2356 | received | 5/22/2023 |
2356 | delivered | 5/22/2023 |
2356 | received | 10/22/2023 |
2356 | received | 10/22/2023 |
2356 | delivered | 10/22/2023 |
the sorting must be based on date and matching number and it should generate empty rows after every delivered type
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You should start by making sure the date column is defined as a date rather than a string. From first glance the Date column looks like a string. You can convert it to a date using the DateTime Parse tool.
Once parsed to a date type the normal sort tool should sort it correctly.
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks for the solution. it was same as required . could you please help me in one more question below is the link
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks for the reply . you to provided a right soution. but the perfect one which work on my dataset as expected is of wwatson
