Passing Value At Run Time

Reply
Highlighted
Yellow 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


Accepted Solutions
Highlighted
Red Belt

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!**

View solution in original post

Highlighted
Black Belt

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"

View solution in original post

NoETL strikes again! Learn how to add parameterized values to your #Domo reports in this accounts receivables use case. ##### CONSULTING SERVICES #### I hav...

All Replies
Highlighted
Red Belt

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!**

View solution in original post

Highlighted
Black Belt

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"

View solution in original post

NoETL strikes again! Learn how to add parameterized values to your #Domo reports in this accounts receivables use case. ##### CONSULTING SERVICES #### I hav...
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.