How can we do what mentioned in the attached Excel file? In other words, I want to get the generated result of below SQL script but without writing it directly into a DB node. The direct writing takes a long time and more spaces.
TRIM(TRAILING ‘,’ FROM (XMLAGG(TRIM(String)|| ‘,’ ORDER BY String) (VARCHAR(10000)))) as Strings
GROUP BY 1
example.xlsx (8.5 KB)