Dashboard query that can select a column based on value from another.

50 viewsDashboard and Query query
1
1 Comment

I am trying to create a dashboard query that can join 2 tables based on port and carrier. The issue I have is that I need to select the value from Carrier1, or 2, or 3, or 4 based on the value of DVB-S2X Uplink Port. (See figure).

Is there a way to write such a query that selects value from 4 columns based on value from Port?

Sebastian Ulloa [SLC] [DevOps Advocate] Posted new comment 2 days ago
Sebastian Ulloa [SLC] [DevOps Advocate] commented

Hi Anna,
Are the Carrier 1, 2, 3 and 4 columns always filled in? Or depending on the port, only one of those will be filled in?

If it is the case that only one carrier will get filled in, perhaps you can use column manipulations to concatenate carrier 1, 2, 3 and 4, and produce a new column that contains the value of the carrier that is populated.