Skip to main content

Is there a way to quickly select only distinct rows in Ataccama One Desktop? 

(I now used a record descriptor and filter with Regex find(“.:.:1”, rd_column)

Hi @Marnix Wisselaar 
Using the Record Descriptor Builder step is certainly the best practice approach to solve this use case.

An alternative to using the Filter step with Regular Expression is to use the built-in expression function word().

I have attached a quick example using the expression function word().

 

Thanks so much. Great how you documented it! Will certainly be added to our cookbook ;)

 

Reply


Community Terms of Use & ConditionsCookie settings