Workflow option to Refresh Sources doesn't apply to Contains Match

James T Sidebotham
James T Sidebotham Contributor
in General

Hi,

I have a validation step that performs a 'Contains Match' on a lookup table (I am checking FK integrity). The workflow is set to 'Refresh Sources' however this does not apply to the lookup table. (I noticed due to failed rows). What is the recommended best practice here?

Thanks

Answers

  • Henry Simms
    Henry Simms Administrator

    What I do in this scenario is include an orphaned source step (i.e. with no connections) in my workflow, configured with the lookup table. This will ensure that it's refreshed along with other sources, but will not interfere with any of the existing logic.

    Because sources are always refreshed before any execution, the refreshed lookup table will be used in the Contains Match function later

  • James T Sidebotham
    James T Sidebotham Contributor

    OK I will do that. Would be nice if there was an option "Refresh lookup table" that was there when the workflow detected that was used in the canvas.

Categories