Workbench - ODBC - Global Replacement Variables - Main use of and how to use them?

BMJProtoLabs
BMJProtoLabs Member
in Workbench

I cannot find any example, post, or video that clearly shows what Global Replacement Variables are best used for and how to use them (ideally in the query unless they aren't meant to be used here)?  I think a solid definition of what the difference is between a 'Replacement Variable' and a 'Global Replacement Variable' would help quite a bit as well!

 

Ex:  Lets say I want to use a Global Replacement Variable to limit multiple Job's query's where clase to include all data since the beginning of 2019, is that a use case for Global Replacement Variables?

 

SELECT *

FROM dbo.employee

WHERE startDate >= <Global Replacement Variable with correct syntax that reprensents 2019-01-01>

 

Best Answers

  • TannerL
    TannerL Domo Employee
    Answer ✓

    A global replacement variable works just as you've described below.  Both the global and non global replacement variables allow you to store the last item in a sorted field in your data set. 

     

    The global version allows you to use that stored value in other jobs while the non global version is only accessible in the job it was created in.  

     

    Additional information about replacement variables, including how to use them, can be found in the 'Connecting to Data using Workbench 5' KB article linked below.  Step 19 gives the details you're looking for. 

    https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Connecting_to_ODBC_Data_in_Workbench_5 

     

    Tanner

    Domo EE
    **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"
  • Matt84096
    Matt84096 Domo Employee
    Answer ✓

    What I understand to be the main difference is that a global replacement variable can be accessed across workbench jobs, whereas a replacement variable is limited to the workbench job you're working on. It's true that the documentation is somewhat limited in this area.

Answers

  • user13374
    user13374 Member

    Can anyone answer this question.

  • TannerL
    TannerL Domo Employee
    Answer ✓

    A global replacement variable works just as you've described below.  Both the global and non global replacement variables allow you to store the last item in a sorted field in your data set. 

     

    The global version allows you to use that stored value in other jobs while the non global version is only accessible in the job it was created in.  

     

    Additional information about replacement variables, including how to use them, can be found in the 'Connecting to Data using Workbench 5' KB article linked below.  Step 19 gives the details you're looking for. 

    https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Connecting_to_ODBC_Data_in_Workbench_5 

     

    Tanner

    Domo EE
    **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"
  • Matt84096
    Matt84096 Domo Employee
    Answer ✓

    What I understand to be the main difference is that a global replacement variable can be accessed across workbench jobs, whereas a replacement variable is limited to the workbench job you're working on. It's true that the documentation is somewhat limited in this area.

This discussion has been closed.

Categories