Q&A BY TAG 'Duplicates'

Hello. I have a view named left_view with 5 rows: column_1 column_2 column_3 abc some value some value def some value some value ghi some value some value ...

Duplicates Distinct primary keys join left join

Hello: I have this input: abc,abc,123,000,123,000 And I need to remove duplicates words. The output must be: abc,123,000 I'm using this regexp: \b(\w+)\b\s,\s(?=.*\1) but it doesn't work. I'm testing in this page were works: https://regex101.com/r/...

Duplicates Regex

Can we make the copy of the folder or database in the same environment in Denodo 6. The clients doesn't maintain the repository - to handle any changes - planning to make the copy of the existing views and make the changes in one copy which may help t...

Duplicates

Hiwe havearun 600 columns in our derived view and select distinct Option in the output tab would generate a vql with select distinct on all the 600 columns. This makes the query very expensive on the data source ( fully delegated). Is there a way to fo...

Duplicates primary keys