Dear All, Could some one suggest me how to extract the data from different sheets within the same file.
Currently I am using Directory tool ->Formula tool (sheet name) -> Batch Macro to extract the data.
But getting error when I save the Workflow into Gallery since files used in Macro cant able to access from local folder.
Regards
Mahadev
Solved! Go to Solution.
Hi @mahadevaswab , is the issue with the macro itself? You will need to either have the Macro stored in a location that Alteryx Server can access, or package it up as an asset in the workflow.
Hi @mahadevaswab Not sure if I understand correctly, but do you want to get data from different sheets within one single Excel file into Alteryx? If that is the case, you could use a normal input tool to get a list of the sheet names, then use a filter tool to select individual sheets and then read in the data using a Dynamic input tool. Ideally, you would not need a macro for that. Does that help?
@Paulomi could you please share the sample workflow