Replacement Variable
I'm using workbench 5 and my current query looks like
SELECT Unique_ID, Incident_Date, Incident_Time, Incident_Description
FROM Incidents
WHERE Unique_ID > !{lastvalue:Unique_ID}!
ORDER BY Unique_ID
In my replacement variables, I have the column set as "Unique_ID" and the value as "!{lastvalue:Unique_ID}!
I've run this query using both the append and the replace update method and everytime it gets stuck returning the message "Replacing Last Value query at position 146" 3 - 5 times a second, sometimes freezing workbench altogether. What am I doing wrong? How do I get the job to run successfully and update the value in my replacement variable?
0
Comments
-
Hi there,
The information you are looking for is in this link;
0
This discussion has been closed.
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 337 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 83 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有