How to find correct syntax for flow variable

Hey all,

I’m working on what I figured was a simple workflow to dynamically grab some data from a bunch of Excel files. The structure of the files is almost identical, but some tabs in some of the files contain fewer or more rows.

The way to extract the data works great in that I can specify the path, including a flow variable per sheet so something like this:

The struggle is after that, I would want to dynamically only pull the sheet area I need. There is a sheet area but it’s configured like this in the node:

All great, but instead of each little input box (Column, Row) being an independent flow variable to override we’re left with having only one flow variable for all of them at once. See below:
image

My question is how do I figure out the syntax of that flow variable? I’ve had this problem at other times where knowing the syntax of a specific flow variable would have been great. Is there a way to generate the output per available variable somehow as a reference?

Thank you

Hi @Fearox

Welcome to the KNIME community!

I happen to have recently helped a fellow KNIME’r with this. Please have a look here, it works for every node.

In your case, the sheet_area represent the radio button to either choose for the full sheet or for a partial area.

Variables output.
image

5 Likes

Thanks that helped me! It was staring me right in the face, I was so looking for “sheet area” that I missed the from/to columns/rows variable. Thanks a lot!

3 Likes