Alteryx to KNIME conversion

[24Sushma]

Can anyone help me convert the following node (Row filter in Alteryx) from Alteryx to KNIME to give the same output?

[ipazin]

Hello @24Sushma,

you can use Rule-based Rule Engine node for filtering. If you need to calculate date and/or time fields before you can use Extract Date/Time Fields node.

Additionally here is useful topic on Alteryx migration:

Alteryx Designer to Knime

I read through the eBook From Alteryx to Knime. It was a good starting point but I still have questions. Would love to have a group of former Alteryx users to ask migration questions of. How do we create such a community group (assuming one doesn’t already exist). I’m build a doc of tools I commonly use and am trying to find the equivalents in Knime.

Br,
Ivan

[24Sushma]

Hello @ipazin ,
I have used Extract Date/Time Fields node to extract Month but not sure what to use for DateTimeToday() function used in Alteryx.

[ipazin]

Hello @24Sushma,

there are couple of ways to get current date but maybe easiest for you would be to use today() function from Column Expressions node and add it as new column. Then you can extract whatever field you want from it. Also you can use Column Expressions functions to get these fields from Date&Time columns - for exmaple getMonthOfYear() for month number.

Alternatively you can hold this information in flow variable to avoid repeating it many times in a table unnecessary. Variable Expressions is Column Expressions counterpart when it comes to variables.

Br,
Ivan

[24Sushma]

Thank you. The solution works.