Passing Value At Run Time

Reply
Highlighted
White Belt

Passing Value At Run Time

Hi All,

 

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

 

Thanks & Regards

usr12321

Highlighted
Major Blue Belt

Re: Passing Value At Run Time

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 the heart icon**

**Did this solve your problem? Accept it as a solution!**
Highlighted
Red Belt

Re: Passing Value At Run Time

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 heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
NoETL strikes back! Jae Wilson shares how to build an accounts receivables aging report with parameterized date values. #Fusion #Domo
Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.