Using a function with a changing input value within a loop

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.