Formula from Alteryx to KNIME

[Subramanyam]

Hi Team,

Could you please help me in converting the below condition from Alteryx to KNIME

ToDate([week_start_date]) >= DateTimeAdd(DateTimeToday(),-37,“days”)
AND
ToDate([week_start_date]) <= DateTimeToday()

Please let me know for further information.

Thanks,
Subbu

[Soybeans0000023]

You can use the node column expressions to do many many of the things you did in the formula tool in Alteryx. This is what I used when I switched over to Knime. Don’t have the exact formula, but hope this helps. Knime’s AI assistant is pretty helpful too.

[rfeigel]

I have no idea what the inequalities you have mean. I assume they are conditions for some kind of if tests. Regardless, this workflow has KNIME equivalents for the individual Alteryx nodes. Check how the nodes are configured.

Alteryx Date Conversiion – rfeigel

[rfeigel]

You didn’t state it explicitly, but appears that you need to find week beginning dates. If so, this workflow handles weeks beginning on either Sunday or Monday.

Create Week Start Date Either Sunday or Monday – rfeigel

[alpayzeybek]

Hi,

Have you managed to solve your problem?

If not, please check the KNIME flow below — it replicates the logic of filtering rows where corresponding date falls within the last 37 days:

Let me know if you’d like me to walk you through the steps.

Best regards,
Alpay

Date Check.knwf (12.2 KB)