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.
In fact (since I just saw another ticket from you) have a look at the course here: https://www.knime.com/knime-introductory-course. It should answer a lot of your questions.
How do I make default variable to take value from string manipulation node?
Managed to use value selection to do this. Is there any other solution to this?
Yes. You can use any of the nodes that have To Variable in their names to convert data cells to variables. There is an example here: https://www.knime.com/knime-introductory-course/chapter7/section1/transforming-data-cell-into-flow-variable.
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 .