I'm trying to figure out why my macro is not being reset correctly within a loop.
I have a "Loop files." Inside that I have a Generate Macro->Generate Report->Add section.
- The Generate Macro creates a macro called "without_extension" with the function "replace(%{file_name},".tsv","")".
- The Generate Report creates an Excel file with report name: %{without_extension}
- The Add section adds to report name: %{without_extension}
I would expect, given three files in the directory being looped, three reports, each with one section added. I get the three reports. However, only one of the three has a section added. If I delete that one from the directory being looped, a different one has the section.
Please help me understand what I am doing wrong setting the macro.
Many thanks in advance.