Dynamic Outputs are not working as expected
I am attempting to pull the values from three columns of the single row advanced query into Dynamic Outputs. I setup and tested my RegEx Find String using Notepad++ using the output I copied from the query. I was able to manipulate as desired in Notepad++, however I am not getting values in my Dynamic Outputs.
The Advanced Query
Where Full Year is a from a Trigger Event prompting for Year, and equates to 2020, and Period Number is also from the Trigger Event, and equates to 2 for the example.
The results look like this:
Start of file contents:
End of file contents:
The Regex match text looks like this:
I use $1, $2, and $3 respectively as the Match Results to capture the three values, but I don't get the data in the variable as a result.