sql: distinct

[anneoctaaf]

I'm using a select as the data source of a datawindow. Now i need all the fields that are NOT empty, but i don't want any doubles:
select distinct(field)
from table
where field <> ""

PB has a problem with distinct, what is de correct function in PB?

Thanx

 

[pgaec]

select distinct field
from table
where field <> ""

what database are u connecting to?

 

[anneoctaaf]

In my database painter that works fine, but i have to make a computed field or something and then in de "modify expression" window i get an error if i put distinct field
I'm using SELECT as a datasource for my dw. so i actually need a function of a computed field, but there is no distict function fgor computed fields. Do you know which other function does the same?

Thanx

 

[pgaec]

u cannot use distinct in the "modify expression" window as DISTINCT is not a Powerscript fn. Instead try using "Surpress repeating values"

 

[anneoctaaf]

Thanx!