What is the use of Select transformation

In Diyotta we have implemented another transformation named Select and we have added Record Id , Unique and Sort options in transformation it self

We can filter records from each group having duplicate id and ascending or descending order by applying multiple options in one place as 

If we click on record id option with out select sort option, by default it take last column with ROW_NUMBER()

We can select multiple attributes for sort option, if we click on record id then it will create attribute using attributes are in sort

We can select multiple attributes as unique and when we select any attribute as Unique, unique output field will enable with drop down conditions and output will generate based on conditions we selected from drop down

If we select unique output condition as ‘The First Record Of Each’, it select only first record from each group

Source Output

Select Transform output

If we select unique output condition as ‘the remaining record from each group’, it shows the records except first record from each group

Source Output

Select Transform output

If we select unique condition as ”the remaining record from each group including non-duplicate records’, it shows the records except first record from each group and includes non-duplicate records if any group have

Source Output

Select Transform output