I am trying to map the key and value from an value return by the big query data source
so, The regex used is this
But instead of getting all the row value i am getting only the first row
and then modified to
Got all the rows but in the dashboard when i try to get the text or value(combine)
platinum_clean is the variable name
for example
${platinum_clean:text}
it returns the text text correctly
when given ${platinum_clean:value} returns value correctly
we have merged the two columns and from the big query we’ll get
like this
12345 - RM | Dashboard in Progress
67890 - GH | Dashboard in Progress
but this returns only one row, but i have many rows, 1. Is there a way can i return all the rows with kay value
and others are not correctly mapping in this below regex
also i am using this variable in query as well, 2. so is there any way i can use both percentcode and :value