Passing Value At Run Time

user11651
user11651 Member
in Magic ETL

Hi All,

 

Is there any way that can be used to pass the value to DoMo Dataflow at runtime?

 

Thanks & Regards

usr12321

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your parameter dataset called "Join Column" and set it to a constant value like 1. You then can utilize the dataflow to add the same constant to the data set you want to filter / parameterize and then join the two datasets together. You can then do filtering based on the dataset and the parameter / webform dataset value.

     

    You can then update the webform dataset to update the parameter you want to use within the dataflow.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Answer ✓

    https://www.youtube.com/watch?v=wmMrnPO9ivY&t=56s

    @user11651 here's a video that shows the design pattern @GrantSmith  is referring to!

    @GrantSmith wrote:

    Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your parameter dataset called "Join Column" and set it to a constant value like 1. You then can utilize the dataflow to add the same constant to the data set you want to filter / parameterize and then join the two datasets together. You can then do filtering based on the dataset and the parameter / webform dataset value.

     

    You can then update the webform dataset to update the parameter you want to use within the dataflow.

     

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your parameter dataset called "Join Column" and set it to a constant value like 1. You then can utilize the dataflow to add the same constant to the data set you want to filter / parameterize and then join the two datasets together. You can then do filtering based on the dataset and the parameter / webform dataset value.

     

    You can then update the webform dataset to update the parameter you want to use within the dataflow.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Answer ✓

    https://www.youtube.com/watch?v=wmMrnPO9ivY&t=56s

    @user11651 here's a video that shows the design pattern @GrantSmith  is referring to!

    @GrantSmith wrote:

    Typically the way to to parameterize a dataflow is to utilize a separate webform dataset with your value you want to filter on. You'll also include a second column in your parameter dataset called "Join Column" and set it to a constant value like 1. You then can utilize the dataflow to add the same constant to the data set you want to filter / parameterize and then join the two datasets together. You can then do filtering based on the dataset and the parameter / webform dataset value.

     

    You can then update the webform dataset to update the parameter you want to use within the dataflow.

     

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories