Merging data from 2 queries

Hi All,

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.
image

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.

TIA
Shan