Ataccama One Desktop - Select only distinct rows

Question

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)

DannyRyan · Accepted Answer

Hi @Marnix WisselaarUsing 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().

Marnix Wisselaar · Answer

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

Reply

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded