Convert comma separated values to row using N1QL

SQL++
1

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 config P
INNER JOIN config Q
ON to_string(P.vendor_id) = to_string(Q.srvr_vendor)
where P.__t=“ntr-ota-server-vnds” and Q.__t=“ntr-ota-serverinfo” and P.refresh_levels != 0

Query Result in Table Format:
hnwid Refresh
43 0 - NAA Initialization and Full File Change Notification
1 - File Change Notification
2 - NAA Initialization and File Change Notification
3 - NAA Initialization GSM + GSM COMPACT
8 - Steering of Roaming for the vendors for which it is enabled

Required Query Result in Table Format:
hnwid Refresh
43 0 - NAA Initialization and Full File Change Notification
43 1 - File Change Notification
43 2 - NAA Initialization and File Change Notification
43 3 - NAA Initialization GSM + GSM COMPACT
43 8 - Steering of Roaming for the vendors for which it is enabled

Appreciate your quick help!

Thanks,
Vikas

2 
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
3

It worked. Thank you so much!