Related to:
GatewaySQL, How to extract value from new updated rows on a dataview
Problem:
How can I extract the last row from a DataView that keeps appending new rows?
Solution:
You can extract the last row of your Dataview by using the Gateway-SQL plug-in to create a new, separate view.
Using this toolkit as an example:
We'll utilize the id(rowID) to extract the maximum value found and display it as a different dataview.
To do this, go to your Gateway-SQL and add the XPATH of the dataview you've wanted to extract
Name your new data view and add the needed sql parameters:
Once applied, you should then see this on your dataview:

To test this, we've added a new row:
You should then see your GatewaySQL picking up the last row from the target dataview:
If you need further help:
- Please contact our support team via the chat service box on any of our websites or raise a support request.
- Make sure you provide us with:
- Background of the issue or request.
- Use cases, requirements, business impact, etc.
- Encountered error messages.
- Log files or diagnostic files.
- Screenshots.
- And other important information relevant to your inquiry.
Comments
0 comments
Please sign in to leave a comment.