Hi, I am trying to convert the comma separated values to rows, using SPLIT function I can able to separate it but it’s not showing each in separated row, instead it is showing in single array which we don’t want. NIQL Query: Select distinct(Q.hnwid), split(P.refresh_levels,",") as refresh from c…

SELECT DISTINCT Q.hnwid, r AS refresh FROM config AS P INNER JOIN config AS Q ON to_string(P.vendor_id) = to_string(Q.srvr_vendor) UNNEST SPLIT (P.refresh_levels,",") AS r WHERE P.__t=“ntr-ota-server-vnds” and Q.__t=“ntr-ota-serverinfo” and P.refresh_levels != 0

Convert comma separated values to row using N1QL

SQL++

vikasreddy September 30, 2020, 2:04am 3

It worked. Thank you so much!

Topic		Replies	Views
Split to array in n1ql SQL++ n1ql	5	1693	October 3, 2018
Array concatenate in n1ql SQL++ query , n1ql	1	1801	October 24, 2018
How can i change output Format in N1QL SQL++	1	721	February 17, 2019
Select query to convert to array of string SQL++ n1ql	1	1404	May 13, 2021
Convert result of a N1QL to array SQL++ query , n1ql	1	2184	May 10, 2018

Convert comma separated values to row using N1QL

Related topics