So, I have a table where the key is a string combined from two other columns (port and carrier). For example port 0 and carrier 1 generates key 0_1.
In Visio I would like to link a shape to a parameter on a row with key value port_carrier, or port,carrier.
How to create variable port_carrier or filter parameter from two columns is my question? is this possible?
To get the right key, you can replace the '[tableindex]' in Joey's answer by 2 [param:...] placeholders. Let's assume your key is user_id and your columns containing the port and carrier have id 102 and 103. A single param placeholder can be built up as follows and outputs the value of your corresponding table cell: [param:<elementName or dmaID/eleID>,102,user_id]. The full Parameter shape data would then look something like this:
- ColumnID:[param:<element>,102,user_id]_[param:<element>,103,user_id]
The param placeholders will then be replaced by their corresponding values and the result of them should be your full key for your 3rd column and your eventual table cell.
Hope that helps. Remember that to debug your setup, it's always possible to pull your placeholders out of the shape data and put them directly in some shape text. This way you can debug where something is going wrong.
For an introductory course to the different placeholders and how they work, you can refer to our Visual Overview training lesson here: https://community.dataminer.services/courses/visio/lessons/creating-a-dynamic-visio-drawing/