This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@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).
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.
@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.
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.