Copy Values across 12 month period

[traceystone]

With the attached workflow. I am trying to copy the total contractor cost to each month for every site. Example:

The total contractor cost would duplicate in each month for 12 months based on the Migration Date + 1 date through the Migration date + 11. This would allow me to calculate total savings for each month in a given year. 

I have attached the workflow and a sample output file.

Ideas on how to tabulate?

[Luke_C]

Hi @traceystone 

You need to export your workflow as a yxzp so the input file stays with it (Options > Export Workflow). It sounds like you want to use the the generate rows tool to get a record for each month. Today's weekly challenge is actually pretty topical for this (although it creates days instead of months). Take a look at some of the solutions posted there for a sense on how it works:

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-310-Maintenance-Schedule/td-p/913603

[binuacs]

@traceystone as @Luke_C mentioned please provide the input file

[traceystone]

Sorry about that. Here is the workflow as .yxzp. I will take a look at the solution you posted

[traceystone]

Input file attached

[traceystone]

I can't open the sample workflow. It is in a new version than I have and can't upgrade.

[Luke_C]

Hi @traceystone 

Here's an example of how to use the generate rows tool for your workflow.

1. Generate rows based on the two dates you calculated (1 per month)
2. Create a 'header' field that is year-month (to keep the columns in order in the cross tab)
3. Cross tab the data
4. Dynamic rename to get the desired format of Mon.-Year

If you ever can't open a workflow due to versioning, just open it in a text editor like notepad and change the version (screenshot below)

[traceystone · Accepted solution]

Thank you!!