How to repeat a single value for each row?

James T Sidebotham
James T Sidebotham Contributor
in General

Hi,

I have a table, that could have any number of rows from 1-60. I want to add a new column that determines the type of run this is for. I use a prior step to create a single value to be used. I know a workflow parameter would be best, but how do I automatically put the earlier determined value into the parameter? Thanks

Answers

  • Henry Simms
    Henry Simms Administrator

    If you're passing in the value of the parameter from another Workflow, or via an Automation, or via the REST API, you'd be able to add the value into a column using the Constant value function and picking the parameter from the list:

    image.png

    Parameter values have to be defined at the point when the workflow is executed, which means you can't assign a Workflow Parameter's value at runtime. For this reason I quite often end up needing to use a Fire Event step (and a Custom Event) in one workflow to take a value from a column and pass it as a parameter to a subsequent workflow.

  • James Sidebotham
    James Sidebotham Member

    Ok Thanks, I will have to play with it.

Categories