Global Replacement Variables syntax

Basketballfan1 · September 2020

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?

jaeW_at_Onyx · September 2020

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 · September 2020

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 · September 2020

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 · September 2020

Thanks Jae, I will check out the Slack group.

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

Global Replacement Variables syntax

Comments

Categories