i got a database with several tables. all the tables are leaded by an ID field, the trick is to put all the entries with the same id together.
my partner tried to do this with a SQL command but hes not working at the moment.
my way:
i tried to use several select(sql) nodes to spit out the table entries leaded by the id. (sorted by id)
i used a SetSlice node for keeping the id as slice-index and then putting the entries to the right slice, and in the next step puttung strings together with +(string).
thougt it will work like that, but it doesnt. setslice is not the best choice i think…
i will prepare a patch to understand it but now its a bit late:)
for the sql thing have a look at join and group-concat. then you’d probably already get the desired result.
if not, try separate to split the ids from the content and try my = String Spectral module to search for equal ids. then add the content back together