Forum Discussion

ricod's avatar
ricod
Icon for Helper I rankHelper I
2 years ago
Solved

Merge excel files and excel worksheets

Hi,   i've need to import a monthy excel reports file, in each file i've 9 identical worksheets structure representing employe planning of the file month. i want to agregate the files i put in a fo...
Need Help
  • ricod's avatar
    ricod
    2 years ago

    hello NaveenGandhi , should be ok now 🙂 thanks

NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
2 years ago

Hi ricod 

I have created a sample solution for the mentioned problem, have a look at [Invidual file all sheets] table's applied steps, I have utilised this steps in the tranform file function for t1 table [I altered my existing transform file function which was taking 1st sheet from all files] so that all sheets in all files in the folder in extracted.

 

Just adding the exapand step in your tranform file would do the job in nutshell.


Let me know if this helps.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

ricod's avatar
ricod
Icon for Helper I rankHelper I
2 years ago

Hi NaveenGandhi here are two sample file  june July . i combine file from folder, transform and after due to date change i'm not able to "merge" then to have full history

 

cheers