Creating a parameter using a value from a table

[Jaden]

Hi all,

I am on version 5.8.0.16 of EasyMorph. I have a value that gets the max date from a table in SQL Server. This value will update incrementally as time goes on and I load more and more data in. Is there a way I can take this value and place it in a parameter to use in later actions? Currently I am manually updating this in the parameter. I am trying to just load in data that has a later date than that max date. Any advice would be much appreciated. See screenshots below for reference. Thanks!

[dgudkov]

Hi Jaden,

You can bring both values into one table (e.g. using "Peek") and then use the "Call" action to call another module with two parameters and assign the parameters with these values.

Alternatively, bring both values into one table and use the "First column value" mode for constants in the query editor (see below).