I have tried a batch macro to read mutliple files coming from a directory tool. I was able to create stacked file using a batch macro.
But i want the data to be joined horizontally as it can be done by Join tool
Hello @Dhananjay_Galphat1 ,
What about this. Try it out and let me know if it works for you.
Regards
Could you explain a little more? (what creteria are you using? What are the conditions?) An example would help a lot with this.
There are multiple files in a directory having above format, only the columns having month/year as header will change. So i want to join all the files in the directory based on product.
