Hi there,
I used a macro to read multiple files into alteryx. The macro works well on tabs A, B, C. But on tab D, alteryx can't read anything. It just shows column title but no content in the columns.
The fact that this macro works for other tabs makes me think coding works. I am puzzled what can cause tab D not to be read in correctly. Have you seen formatting issues in excel that would cause the entire tab not be read?
Alteryx flow looks like this
Directory -> Formula([FullPath]+"|||Asset Characteristics") -> Macro
Thanks,
Yiling
Solved! Go to Solution.
I know it's weird...
Col A does not seem to be the problem...deleted A and the issue remains.
If you can, remove the data that might contain sensitive information and include the Excel file as attachment. I would like to try on my system. You can delete the other tabs.
I was successful in importing with both an input tool and a macro. One last thing to check is the formula tool that is updating the path. Can you share the configuration for that tool? If that tool is set up correctly, we might just want to recreate the macro or try in a different workflow to eliminate possible file corruption.
Try updating the formula to [FullPath]+"|||'GHG$'" The only differences are the single quote around GHG and the dollar sign ($). That should read it in correctly though.
ah, tried [FullPath]+"|||'GHG$'"... it did not fix the issue.
Thank you very much. It worked.
Woohoo!