I want to get a collection which is containing the input from an sql tabel, but as well distinct values of one single column from the same table. ClearCollect(StructureCollection;ShowColumns(Distinct('[dbo].[Structure]';"Entity_Key");"Entity_Key"));; Collect(StructureCollection;'[dbo].[Structure]')
So the output should be the table and distinct values of one column, where all the other columns are empty.
Can anyone come up with an idea of solving this problem?