Hi i am facing an issue with the Alteryx Version 2024.1 version having AMP engine while running my Old Workflow which is been build in the previous version.
As when i am trying to dynamically input my file containing temporary test data, the first macro takes the data and creates a new column with full path which contains the full path of the excel file in concatenation to sheet name.(
This macro takes the FullPath field (XLSX file and directory) and updates the Input Data tool. The Input Data tool outputs the list of sheet names from the current Excel file. It also outputs the Full Path as an additional field.
A Formula tool then builds the string of FullPath+Table/Sheet name. Notice that it also adds a "$" to the end of complete string. The Select tool removes everything except the constructed string from the Formula tool and is then fed into the next macro.)
But as the data goes to 2nd Macro (This macro simply takes each sheet from one Excel file and opens them one by one, unioning all results at the end and returning to the first macro.) it didn't get execute , it just throws an Error that " Sheet Name does not match a sheet or named range in File.xlsx or the file is corrupted .
Please can anyone help me in solving the error? Pasting below the error screenshot for the same.
