DSXchange

Could you add 2 transformers ?
1 concatenate all fields of dataset 1 into 1 single field varchar(xxxx)
the other does the same for dataset 2
and then funnel both streams.

Hi ArndW, I think this is not doing the same thing because I don't want to check if my field is equal to any of the unwanted word but I want to check if my field contains any of those words ... This is the "contains" part which causes me trouble. It's the same pain in SQL when you have to ...

Hi there, I'd like to know if someone would have a trick to check if a field does not contain any word in a list of words. Something doing the check : If Index(ds1.field,"word01",1) + Index(ds1.field,"word02",1) + Index(ds1.field,"word03",1) + ... + Index(ds1.field,&quo...