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?

Find more posts tagged with

Comments

jaeW_at_Onyx

not my strong suit here... did you get it resolved?

https://dojo.domo.com/t5/Workbench/Workbench-ODBC-Global-Replacement-Variables-Main-use-of-and-how/td-p/45499

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

(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/

Basketballfan1

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.....

jaeW_at_Onyx

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.

Basketballfan1

Thanks Jae, I will check out the Slack group.

BTW, I've used your You Tube before, it's been very helpful.