What is the use of Select transformation
i want to know 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