🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Using a function with a changing input value within a loop

User: "rachel_lomasky"
New Altair Community Member
Updated by Jocelyn

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.

 

 

 

Find more posts tagged with

Sort by:
1 - 1 of 11