SOLVED
Generate Rows
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
rickydata
7 - Meteor
‎02-14-2023
11:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm looking to generate rows between data.
Currently what i have is
Person | Month | Data |
Person 1 | 1 | X |
Person 1 | 6 | X |
Person 1 | 7 | X |
Person 1 | 8 | X |
Person 1 | 9 | X |
Person 1 | 10 | X |
Person 1 | 11 | X |
Person 1 | 12 | X |
Person 2 | 1 | X |
Person 2 | 6 | X |
Person 2 | 7 | X |
Person 2 | 8 | X |
Person 2 | 9 | X |
Person 2 | 10 | X |
Person 2 | 11 | X |
But I want to make it look like
Person | Month | Data |
Person 1 | 1 | X |
Person 1 | 2 | null |
Person 1 | 3 | null |
Person 1 | 4 | null |
Person 1 | 5 | null |
Person 1 | 6 | X |
Person 1 | 7 | X |
Person 1 | 8 | X |
Person 1 | 9 | X |
Person 1 | 10 | X |
Person 1 | 11 | X |
Person 1 | 12 | X |
Person 2 | 1 | X |
Person 2 | 2 | null |
Person 2 | 3 | null |
Person 2 | 4 | null |
Person 2 | 5 | null |
Person 2 | 6 | X |
Person 2 | 7 | X |
Person 2 | 8 | X |
Person 2 | 9 | X |
Person 2 | 10 | X |
Person 2 | 11 | X |
Person 2 | 12 | null |
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
7 REPLIES 7
SPetrie
13 - Pulsar
‎02-14-2023
11:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
prpatel
11 - Bolide
‎02-14-2023
11:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
16 - Nebula
‎02-14-2023
11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx
‎02-14-2023
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rickydata ,
You can utilize the generate rows and a batch macro to achieve your desired outcome.
binuacs
21 - Polaris
‎02-14-2023
12:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-15-2023
12:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This one is good for when you have a single field, but within the scope of my data are several fields. Thanks
‎02-15-2023
12:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This one is great! thanks. Simple and can expand with data with multiple fields.
![](/skins/images/03E14B015E5210679CFB65D9FFC7B381/responsive_peak/images/icon_anonymous_message.png)