You’ll receive this Excel sheet as to proceed to our analyze.

It contains 36 sheets grouping sailings from 01-2020 to 12-2022.

To combine our different sheets, 4 steps are necessary:

1. Supply an Excel file, containing sheets/tabs that we want to combine.
2. Convert the Excel sheets into variables and create a loop.
3. Read the sheet corresponding to the actual variable.
4. Keep data of the sheet that had just been read and skip to the next variable.

Now that we have incorporated the logic behind our method, it is time to build our workflow:

Step 1:

Double-click on the node Read Excel Sheet Names to give the location and the file which we are working with. That node will have 2 output columns: Path ( location of the sheet ) and Sheet ( appellation of the sheet ).
Yet it is the Sheet column that is important since it will be converted in the next step, into a variable.

Step 2:

The configuration of the node Table row to variable loop starts :

The green box is the location where we insert the columns that we want to convert into variable.

In our case, we want to extract data for each sheet’s name in the file. We then need the sheet’s name, in that case Sheet, to be in the green box to be the variable that leads to the loop. Now that we are configured, we can execute the loop.

Step 3:

Now, we are going to configure the Excel Reader loop.

First, we are going to supply the file from which we want to extract data, then we are going to give the variable that contains the names of the sheets we are trying to combine. To do so, we need to click on the Flow Variables tab.

Click on Settings then select sheet in sheet_name as it is shown:

Step 4:

Last, and easiest step, it is now about configuring the Loop End according to your preferences.

Now that all our nodes are configured, we can execute our workflow.

Once the loop done, the final table should look like this: