How to join (not union) multiple files which are having different schemas from a directory

[Dhananjay_Galphat1]

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

[afv2688]

Hello @Dhananjay_Galphat1 ,

Could you explain a little more? (what creteria are you using? What are the conditions?) An example would help a lot with this.

Regards

[Dhananjay_Galphat1]

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.

[Qiu]

@Dhananjay_Galphat1 
Multiple Joint is not working for you?

[Dhananjay_Galphat1]

I want to read all the files in one go using directory tool.

[afv2688 · Accepted solution]

Hello @Dhananjay_Galphat1 ,

What about this. Try it out and let me know if it works for you.

Regards

[Dhananjay_Galphat1]

Thanks a lot. 😌