Input Multiple Files and getting output with multiple files

[yashavantharaja_thim]

Hi Team, 

I have attached the use case here and  my requirement is Input Multiple Files and getting output with multiple files. Kindly help me 

[afv2688]

Hello @yashavantharaja_thim,

Do the files share the same column names and data types?

Regards

[pedrodrfaria]

Hi @yashavantharaja_thim 

You can leverage the attached macro to open multiple files at once. I'm assuming they are xlsx. Let me know if they are not.

I attached an example with some files as well.

[yashavantharaja_thim]

No Different columns and data type

[yashavantharaja_thim]

All are .xlsx files... Input each files having same company in different excels and i need to spit company wise keep the in tab 

[pedrodrfaria]

@yashavantharaja_thim 

Does the WF I provided help you? If not, can you let me know what else is needed?

[yashavantharaja_thim]

No it is not working here i attached the requirement 

[yashavantharaja_thim]

Input files

[yashavantharaja_thim]

no it wont work