SOLVED
Adding rows based on time frame and criteria
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
Neico
7 - Meteor
‎11-24-2021
11:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
My data is in the following format:
ID | Type | Year | Month |
5 | low | 2009 | 1 |
5 | medium | 2012 | 3 |
5 | high | 2013 | 5 |
I would like to add rows such that the data fits into the desired time frame from 1-2008 until 6-2021 and takes the corresponding "Type" variable:
ID | Type | Year | Month |
5 | 2008 | 1 | |
5 | 2008 | 2 | |
5 | 2008 | 3 | |
... | ... | ... | |
5 | 2008 | 12 | |
5 | low | 2009 | 1 |
5 | low | 2009 | 2 |
5 | low | 2009 | 3 |
... | ... | ... | ... |
5 | low | 2012 | 1 |
5 | low | 2012 | 2 |
5 | medium | 2012 | 3 |
5 | medium | 2012 | 4 |
5 | medium | 2012 | 5 |
... | ... | ... | ... |
5 | high | 2013 | 5 |
5 | high | 2013 | 6 |
... | ... | ... | ... |
5 | high | 2021 | 6 |
I really appreciate your help!
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
1 REPLY 1
Sebastiaandb
12 - Quasar
‎11-24-2021
10:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Neico,
This should work for you :-)!
Let me know if it gives you the right solution!
Greetings,
Seb