Hi all, I have a question. I am looking for the possibility to add a column with a fixed value to my excel file. However this fixed value should come from the title of the excel file, for example: the file is called 20200605_921_TK.xlsx. I would like to add a column with the fixed value of 20200605, a column with 921 and a column with TK. Can anyone help me out on this, if this is possible? Thanks in advance! Sander

The process is actually very straight forward. What you want to do is create a variable from the file name you read. Likely you will strip off the path of that variable to be left with just the filename. Then use a cell splitter to break the filename down by the underscore. I attached a simple example using an exce Sample 1.knwf (21.4 KB) Address Verification Codes.xlsx (16.2 KB) l file. But I used a space as the divider instead of an underscore. But I think you will get the concept.

Add column with fixed value from title of Excel file

KNIME Analytics Platform

ipazin September 18, 2020, 9:17am 6

Hello @gregmurphy,

check out here how to share your solutions with Community (and welcome to it!):

Br,
Ivan

1 Like