Global Replacement Variables syntax
I understand the use of Global Replacement Variables compared to Replacement Variables but I can't get it to successfully get it to run. I can get the Replacement Variable to work fine but when I try to make it a Global Variable, I get this error.
"Replacement parameter does not contain a value for column Incremental_id"
I have this statement in my query:
Where Incremental_id > !{lastvalue:Incremental_id}!
Does anyone know if the syntax is different for Global Replacement Variables?
Comments
-
not my strong suit here... did you get it resolved?
(section 19)
the documentation suggests the syntax should be the same.
did you see the fine print that you must include the reference to the replacement variable in the SELECT, WHERE and ORDER BY clause and that it is case senseitive/
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"0 -
Hi ,thanks for your response.
Yes, I've read the documentation you mentioned and didn't see anything I am missing. Yes, I have variable in the select, order and where clauses.
Still haven't figured it out.....
0 -
https://join.slack.com/t/domousergroup/shared_invite/zt-dxq99gyf-MBatRTzIbpUAqTCYfDDJZw
Pop into the global slack, for the domo user's group, we have a guy William who is a guru at workbench related stuff.
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"0 -
Thanks Jae, I will check out the Slack group.
BTW, I've used your You Tube before, it's been very helpful.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 727 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive