I have a created a table with columns A and B, we are using KV store to get the threshold config data and KV
Store in response providing table column names as ...
KV Store is also having a column (component_id) value of which is same as column A in other table.
I want to filter the KV Store's column .. based on the value of column B and column A.
I tried using a macro with 2 parameters in first input passing the column A value and other parameter passing column B value.
Here is my macro query:
lookup KVStore_thresholds_config component_id | table component_id, Overtide..thesholdValue | transpose 1000 | addtotals | fields - row |
where column = $y$ | table column, Total
But its not working, macro is not searching the desired result, also it is overwriting previous table fields.
Can someone help on the possible ways to get the required result from the KV store.