Adding Sheet Names as a column in a table

Hi forum,

I am reading data from multiple sheets in the same Excel file. Each sheet contains the same columns and differ in the number of rows. Each row represents a Field record. Each sheet name represents an Object name. I have managed to successfully combine all the rows form the different sheets into one table using a loop. However I need the sheet names to to populate in a column within the same table in order to illustrate which Fields records are specific to each Object. Is it possible to do this?

Hi @Tjaart , I don’t think there is an option in the Excel Reader to do this (maybe there should be), but if you are using an Excel Reader in a loop, then I’m guessing you must have sheet name as a flow variable, in which case, you could add a “Variable to Table Column” node immediately after the Excel Reader, and append the sheet name that way.

2 Likes