Hello everyone,
I just started learning Alteryx this month and have begun on my first use-case and I have been stumped by this for half a day. Intense googling didn't offer any solution, so here am I.
So, I want to duplicate rows that has a "Flag = 1" and add 6 months to the existing [Date] value for the new record.
I spent an inordinate amount of time to get 'Generate Rows' tool to work but the closest I got was for the date to get replicated till eternity (error) as I couldn't stop the loop. The tutorial in the tool only had examples for creating a new column, which does not suit my purpose.
Feel like it should be a simple solution but for I just can't figure this out for the life of me. Grateful for any help!!
Thanks in advance!
Below a sample of my data.
Input:
| ID | Name | Date | Flag |
| 1172569 | Small Company | 01/07/2024 | 1 |
| 0760389 | Mid-sized Company | 01/04/2024 | |
| 1402646 | Medium Company | 01/08/2024 | |
| 1580926 | Average Company | 01/09/2024 | 1 |
| 1498636 | Enormous Company | 01/10/2024 | |
| 1332415 | Giant Company | 01/07/2024 | |
| 1285462 | Gigantic Company | 01/04/2024 | 1 |
| 1291444 | Humongous Company | 01/04/2024 | |
Desired Output - additions font formatted for easier sighting:
| ID | Name | Date | Flag |
| 1172569 | Small Company | 01/07/2024 | 1 |
| 1172569 | Small Company | 01/01/2025 | 1 |
| 0760389 | Mid-sized Company | 01/04/2024 | |
| 1402646 | Medium Company | 01/08/2024 | |
| 1580926 | Average Company | 01/09/2024 | 1 |
| 1580926 | Average Company | 01/03/2025 | 1 |
| 1498636 | Enormous Company | 01/10/2024 | |
| 1332415 | Giant Company | 01/07/2024 | |
| 1285462 | Gigantic Company | 01/04/2024 | 1 |
| 1285462 | Gigantic Company | 01/10/2024 | 1 |
| 1291444 | Humongous Company | 01/04/2024 | |
