Are you talking about this part of the file name being "odd": "%Question.ControlParam.Mapping Control Parameter%"?
Is the workflow actually a macro? In the workflow that calls the macro, whatever value is specified when the macro is called.... that "value" then has "_Cost_Center_Mapping.xlsx" appended to the end.
Example: the macro's control parameter may ask "for the Excel input file for Cost Center Mapping, which prefix should be used?"
Chris
Hi @ChrisTX ,
Yes, the workflow is a macro apart of a larger workflow. I have checked the mapping files and none of them match the format of the input data tool so I am not sure where this is coming from.
In the workflow and the macro, under configuration on the left, under the Runtime tab, click the checkbox for Show All Macro Messages.
When you run the full workflow, there should be a line in the log file that lists how many records were read and the full path for the input file name that was read.
Chris