Hello,
I have a table in my dataminer that displays information retrieved via a probe. I would like to use visio to display a specific column (for example just the id) of the last row received by the probe. Thanks in advance !
Aymeric
Assuming you have an indication on the last change in one of your columns, here's what you can do.
Taking
- Column to retrieve: 101
- Column that contains last change date: 102
- Element called "E1"
Set a shape with shape data
- SubscriptionFilter - SORT=102|DESC
And shape text
- [param:E1,101]
Now, this will return your entire column, with pipe separated values, but your last updated row will be the first entry. e.g. "A|B|C", where A is your column value for the last updated row.
At that point, you can use a regex to match this first entry, wrapping the param placeholder inside it. Your shape text then becomes
- [regexreplace:^([^|]+)\|(.*)$,[param:E1,101],$1]
Not sure if this will match your use case, but hope it helps in any case.