INDIRECT() or similar functionality in Knime

[Nick9403]

Is there any Knime functionality similar or same as ‘INDIRECT()’ function in Excel?

If yes, could you please help me with it?

[gonhaddock]

Hello @Nick9403 and welcome to the KNIME forum
I 'm not sure that you can translate all the excel mindset into analytics. I’ve used INDIIRECT() before in excel in order to map cells; I don’t see it necessary here, as information is stored in columns and there are plenty of nodes (GroupBy, Filters family, Rule Engine, Column Expressions) beside scripting ones.

Can you provide an example on when and need of using it? I’m quite sure there will be a few KNIME approaches to achieve the proposed result. Including import data.

BR

[iCFO]

You can use the Counter Generation node to add a column that allows you to reference row lines in formulas. Perhaps that helps?

You can also reference columns by their position.

Platform wide support for referencing columns by position number

Hi @iCFO , currently this can be done via the Column Expressions. You can access by index or by column name, hardcoded or dynamically via variables using the column() function. I built a quick demo for you: [image] Input table: [image] I defined these 2 variables as sample that I used in the demo: [image] Let’s look at the 4 different expressions (2 hardcoded, 2 dynamic): Exp 1: Access by hardcoded column name (the most common one): column("third column") This will access the column wi…