I have an Input.xlsx file being read during Get Transactions. The input file is basically the 7 report names and some parameters being brought in during Process Transactions. Some of these reports get run from Today through End of Month, and others are Today through End of Quarter.
I know I can split the reports into different workflows and call them using IF Transaction = (matching number/range) and use the arguments defined earlier in the process, but I expect there’s a cleaner way to do it by using the same Input file and mapping the value to a defined variable.
IE Input File Column EndDate
Report 1: EOM
Report 2: EOQ
EOM maps to the EOM variable that’s been assigned, and EOQ maps to the EOQ variable that’s been assigned.