Manel88 Hi Manel,
Looking closely at your workflow, I could think of two solutions to pick up all your data from the folders without using the append.
The first one is simple and requires only two steps:
1) Include a merge process between the folder and the destination. (this will merge all files in the folder)
2) Change the tab: instead of “every first sheet”, please select “CSV FILE”
And that’s it! All your files in the folder will be consolidated in - one - destination tab.
HOWEVER I also check your formulas and all the manual work you do. As we’re an automation tool, I’d recommend some changes to avoid using a lot of formulas (a lot of formulas make your file heavy) by merging and filtering by query, for example:
This means: Sheetgo will pick up all CSV files in each folder and then merge them.
Before transferring to the tab, the filter by the query will bring just the columns you need
And the filter by the query is simple just SELECT and the columns, for example: select D, E, F, G, H
If you have doubts, please feel free to contact me.
