thanks for the fast answer!
I probably didnt explain myself right, so heres an example
I have a table with:
FIELD 1 , FIELD 2, FIELD 3, FIELD 4, FIELD 4, FIELD 5
what i do now is
FIELD 1 as FIELD_1_X (that has other reasons)
FIELD 2 as FIELD_2_X
FIELD 3 as FIELD_3_X
FIELD 4 as FIELD_4_X
FIELD 5 as FIELD_5_X
Now for example it is possible i have an entry where all fields are the same except FIELD3, since it isnt the same entry overall it will be loaded. When i remove FIELD3 from the expression it works obviously.
I want it loaded but excluded in the distinct expression.
if I understand
FIELD1 & '|' & FIELD2 & '|' & FIELD4 & '|' & FIELD5 as checkfield // field used for check distinct
STORE t into t.qvd (qvd);
DROP Table t;
load * From t.qvd (qvd)
Where not exists (checkfield); // only load distinct FIELD1..2..4..5
//DROP Field checkfield;