Parameterization of Date/TimeConfig for DB Table Reader Custom SQL follow up

[ebarr]

This is a follow up from Parameterization of Date/TimeConfig for DB Table Reader custom SQL - #6 by ebarr to @hmfa

I thought we are all set, but I don’t know what I’m missing. Based on your response, I connected the date time config to a merge variables node but when I run it, the varStartDate and varEndDate that I created aren’t showing up :

but when I open the component, the variable names are reflected in the output node:

Am I missing something basic?

date config node:

[takbb]

Hi @ebarr , by default, variables created within a component do not get exposed “down stream” from the component.

To make them available, you need to open the configuration of the Component Output node, and then you can choose which flow variables to be made available outside of the component. Hope that helps.

[ebarr]

That’s the piece I was missing! VERY grateful - I’ve been trying to figure this out for quite some time. That was the solution

[hmfa]

Thanks for the help @takbb and I’m sorry for the late response.

You can look at this pdf for more information about components.

https://docs.knime.com/latest/analytics_platform_components_guide/index.html#components-scripted-components

Br