I am uploading an excel file to knime, the file is called C:\File 01062024, I would like to create a column with the name of the file, is that possible? For example, when you load in Knime it looks like this. Product Value File X 10 C:\File 01062024 Y 20 C:\File 01062024 Z 30 C:\File 01062024 It is possible that when the Excel is loaded, you can add that column with its name, another question that happens if there are multiple files that have the same structure and I would like them to be loaded in a single table but with a column that has the name of each file

Hello @Aprins Take a look into the following post. It can be useful for your use case: [image] Filename as column where constant value column has a names of the files KNIME Analytics Platform Hello @Averin7777 If I understood correctly. You have the option in the ‘Excel Reader’ node >> ‘Advance Settings’ tab >> ‘Append path column’. Then, you will get the Path already posted on every row. [image] [image] Afterwards you can follow the two nodes flow showed in my previous post: [image] BR BR

Put the file name in a column

KNIME Analytics Platform

gonhaddock August 1, 2024, 3:27pm 2

Hello @Aprins

Take a look into the following post. It can be useful for your use case:

3 Likes