How to assign a variable value to a column value

Mahulima
Mahulima Contributor
edited December 2023 in General

I want to assign the value of a column to my Workflow Parameter value.

Ex. I have list of the columns like (Rule name, Group Name, Failed row, Passed row etc), I have workflow parameter "DQ Rule". Now I want to assign value of "Rule Name" to my Workflow Parameter "DQ Rule"

Tagged:

Answers

  • Mahulima
    Mahulima Contributor

    @Sueann See I have already tried both of them. But both are for some default value. 1st approach I can only enter some fixed value in the 2nd approach also I can only enter some fixed value at the runtime. But I am looking for an option where it can store the variable value in the workflow.

    For Ex I am trying to notify my users when the DQ rules score reaches less than 95%, And in the email body I want to mention the Column/Rule Names for which it is less than 95%

    In an workflow I am checking on 10 Columns and lets say out of 10, 2 columns are having less than 95% DQ Score. So in my workflow parameter I want to pass those 2 column names, so that when I Fire an Event and Notification sent to user I can include those 2 Column Names

  • Mahulima
    Mahulima Contributor

    @Sueann See Is it possible to send the Rule report in an email as an attachment to the users?

  • Mahulima
    Mahulima Contributor

    thanks @Sueann See . For the time being I am doing the 2nd approach only

Categories