Hello,
I have a workflow that produces an output document (current output shown below). What I would like to do is add an entire set of duplicated data but only change the month number. (future output show below on right)
So my existing workflow provides me data output for month 2 (February) but I need to report out two months 2 & 3 (February & March) where I want to get to is a two month snapshot (current month & future). The data will be exactly the same except the column for month number.
Can this be done? Trying to get away from manually doing this type of stuff in excel.
Thanks,
Solved! Go to Solution.
There are a few ways to approach this. See below example using a union tool and generate rows tool. Both options add 1 to the month field and result in the data being repeated.
Works like a charm. Thank you