I have modified the Macro from this post https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
but when I run it, the output from the macro doesn't return to it's call.
Please help and Thanks!
@sonseeahray - can you try using the approach in the attached version? In this version I manually construct the file path + excel sheet tab names that get passed to the macro.
EDIT - please use the file named excelFileReader.yxzp
@sonseeahray - can you try using the attached workflow to read in your files? I have coded it to read multiple CSV files from the Directory tool folder, but you can change it as it suits your case. Within the macro, the points to note are highlighted in the image below.
Hope this helps.
Hi @AbhilashR I'll give it a try. Thank you
@AbhilashR how are you selecting the Interface Properties?
@AbhilashR I am missing something, because I'm getting the same results. Is it in the interface properties where I need to set autoconfigure by name?
