Hi all,
in the "Appear X Platform" connector, the "Output Redundancy Settings" and "Output Redundant Sources" tables contain similar parameters. I need to be able to retrieve this data as a single table within a dashboard. I have already tested a query using a JOIN, but it did not work. What options do I have to retrieve the data as a single table in a dashboard?
Desired result for the dashboard.
Thanks and best regards
Christoph
Hi Christoph,
Indeed we need to use a JOIN to accomplish this. In this case, I used a LEFT JOIN, with the two columns I selected being the Display Key from the first table and the IP Switch Output Redundant Settings Key column from the second table, which is the link key between those tables. After doing that, I just added a small filter to avoid showing rows that don't match, i.e., rows available in the first table but not in the second one, and I ended up with a result like this:
This is the query I built, hope it helps
Let me know if this works for you!
I originally wanted a different representation, but your approach worked. I have another problem now because I have to perform so many joins, I'll explain that in a separate reply. Thanks