Hi all,
I'm working on a workflow that will take in a budgeted number of reports per week and will compare it with the actual number of reports per week, then adjust the budget accordingly. Since I need this workflow to be dynamic and work for any given weeks and any given number of weeks, I'm trying to use the dynamic select tool.
In the attached image you can see the layout of how the fields in the join will look. I will be joining on category, then I need to select all the fields from the left side which are the actuals. These column values will be changing week over week. Then I need to select all the fields from the right side (the budget) that match, so any field containing "right" in the rename.
I need help writing a formula for the dynamic select tool which will do as I described above. Here are the specific steps:
1. Select all left fields
2. Select all matching right fields
3. rename left fields to "actual" + week range
4. rename right fields to "budget" + week range
I would upload the workflow for ease of use, but it's very large and contains sensitive information. Thank you in advance for any help or guidance! Please let me know if you have any questions.
