Skip to content
Advertisement

Tag: powerquery

Present URI in database as clickable link

I have a table in a SQL Server 2019 that stores URI’s like this: These values are stored as nvarchar. Is there a way to make these clickable? So that, when this table is for example read by PowerQuery users only have to click the link to open the file? It is assumed that only those filetypes are allowed for

How to combine rows with the same ID into a list

How can I make the below table like a list. I want the result to be like this Any ideas? Answer try the following, it may solve your problem. Let’s say your existing table name is yourTable and the new table to be created is groupedNames. in data view, click on new table and paste the following:

Advertisement