i need some help on the Data merge query/transformation.
I am using 2 data sources in my panel.
Query 1: Infinity to pull data from API for example status for a certain incident.
Query 2: CSV file which referes to certain keys and their values
I am trying to get the key (e.g. Status = Closed)visualized in the table instead of values.
Could someone please suggest how can i reference data from Query 2 to Query 1.