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!
Solved! Go to Solution.
@sonseeahray - running the solution I sent you, it works as expected. In my example I sent two csv files to be read by the macro, which reads test1 and test2 csv's (both also included in first image). The output of the macro is visible in the browse tool in image 2 (and matches the data in test1 and test2 csv).
Image1
Image2
Can you confirm the count of records across the various input csv files you are passing into the fileReadMacro?
Reattaching my workflow with the individual csv files for your to look at.
@AbhilashR I'll try it with your files. Does it matter that I am trying to read .xlsx files?
@sonseeahray - it shouldn't. You just need to modify the Directory tool and the Input tool inside the macro to use xlsx instead of csv file to get this to work. I have modified my solution to now read .xlsx file and reattached it here.
Hope this works out!
@AbhilashR I got your workflow with the csv files to work perfectly, but not the xlsx one. I even saved the macro in the same directory as the files and I cannot get the results to return.
There are 22 files in the directory. The first file, chosen as the file holder has 300 records. I think it is something really obvious 😃
Screenshots from test.yxmd
Screenshots from fileReadMacro.yxmc
Hi @sonseeahray - can you share your .xlsx file with sample data? I would like to test your file on my machine and see.
@AbhilashR I am not able to share a file because it will contain information I am not able to remove.
@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
@AbhilashR I appreciate you continuing to help me! I'll give it a try
Hi @AbhilashR, sorry that I am still having the same issue. The workflow and macros to work perfectly with your test files, but when I pointed to my directory (full path and then I saved the workflow and macros within the directory itself) nothing returns from the fileReadMacro.
test workflow
fileReadMacro workflow
HI @sonseeahray, I am afraid I have run out of ideas at this point, unless you are able to provide your excel file but with dummy data.