I am using a function to inject an sql query to our database to get value for a table.. Everything is workning nice so far but i have a query where i sometimes recieve 2-3 values from a colum which gives me redundant information.. I want to concatenate this to a single row but as i looks i can not u…

[image] RuneStone: SQLanywhere Doesn't SQL Anywhere have LIST and XML Path? SELECT LIST(name, ', ') FROM cities GROUP BY state; SELECT STUFF((SELECT ', ' + name FROM cities WHERE state = c.state FOR XML PATH('')),1,2,'') FROM cities c GROUP BY state

i can not access the code from this computer.. I will look tomorrow and post the query. Don't remember exactlly which node i used but it is a simple connection node where i use the windows driver for the obdc to sql anywhere 17.. query is from 4 tables which i join and where order = x, x is my input…

Feed the output of the query into a debug node and show us what you get. Also tell us what you want to get as the result, for the debug output you have shown.

[bild] This is the output.. i want to have a new row for each different tool name which i have now, but i want to concat the store place in the same collum when everything else is the same

[image] RuneStone: i want to have a new row for each different tool name which i have now, but i want to concat the store place in the same collum when everything else is the same Please tell us exactly what you want to get out for the example you have shown, not words describing it, which wi…

I dont think that is possible in standard SQL. You could do some post processing in node-red. Add a function node AFTER the SQL node... const arr = msg.payload; //payload is the array of objects from DB const parts = []; //results const reg = {}; //registry monitor arr.forEach(e => { let row = …

Yes.. that is a solution i have conciderd.. I tried yours and it works fine so thank you for that.. However in at least msql i think you can conc() direct in the query.. I will use this solution for now but i am pretty sure i will have the same problem in the future when i create more tables so i wi…

[image] RuneStone: msql Do you mean mssql? MSSQL... declare @Yourtable table (part_no varchar(100), store varchar(100)); insert into @Yourtable values ('123','store a'),('123','store b'),('456','store b'),('456','store c'),('999','store c'); select part_no, string_agg(store,',') …

[image] RuneStone: msql Do you mean MySQL? MySQL... CREATE TEMPORARY TABLE Yourtable (part_no varchar(100), store varchar(100)); insert into Yourtable values ('123','store a'),('123','store b'),('456','store b'),('456','store c'),('999','store c'); SELECT part_no, GROUP_CONCAT(st…

Node-RED

Node-RED Forum

Concat in sql query using sql anywhere

General

zenofmud 7 April 2022 20:30 2

What exactly is the query?
Can you get it to work outside of node-red?
What node-red node are you using?

Topic		Replies	Views
N queries in 1 Node mysql General	3	117	28 April 2023
Extracting data from arrays and concatanating General	6	96	10 October 2024
Organize values in SQL General database	2	211	20 January 2023
Pass msq payload to SQL query where clause General	6	740	23 March 2022
SQL SERVER Node General node-red-contrib-mssql-plus	10	199	4 October 2024

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Concat in sql query using sql anywhere

Related topics