I have a flow which will read in excel file and the file name will be something like “testing_20181128.xlsx” for today, and “testing_20181129.xlsx” tomorrow.
However, I have to manually go into the excel reader configuration to change the file. Is there any way I can set the file name as variable and then use it as my file name in the excel reader?
Sure. Just click on the flow variable button next to the file name input you highlighted and choose the flow variable you want to use. There is a section devoted to Flow Variables in our E-Learning Course here: https://www.knime.com/knime-introductory-course/chapter7/section1.
I had try to open file using flow variable. But, I got problem on XLS Reader that //THE “XLS_LOCATION” parameter controlled by a varible and when I click appear notice like this .