This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Having a tough time putting this together. I have these two tables. Is there a way to do this in-db and regular flow.
If you're using In-DB, I assume you'll need to do a few steps:
Summarize Table 1
Group BY Task ID and Concatenate Resource Name with separator ","
Inner Join IN-DB the result of your summarize with Table 2.
How do you concatenate resource name across rows (In-Database)?
Using Summarize IN-DB
Add Resource Name as String > Concatenate
I don't see the concatenation option for Summarize in-DB
Hmm maybe this option is not available with IN-DB Summarizing and I'm mistaken.
Why don't you try to write a query in your Connect In-Db with this table?
SELECT ID, STRING_AGG (Resource Name, ',') AS Resource Name FROM Table 1 GROUP BY ID;
SELECT ID, STUFF((SELECT ',' + Resource Namme
FROM Table 2 AS T1
WHERE T1.ID = T2.ID
FOR XML PATH('')), 1, 1, '')
FROM Table 2 AS T2GROUP BY ID;
Then you don't need to do this Summarize step.