RE: What is the use of Select transformation

i want to know the use of select transformation

Karthik78 Beginner Asked on May 18, 2020 in Diyotta Studio.
Add Comment
1 Answers

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()

RE: What is the use of Select transformation

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

RE: What is the use of Select transformation

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

RE: What is the use of Select transformation

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

Source Output

RE: What is the use of Select transformation

Select Transform output

RE: What is the use of Select transformation

 

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

RE: What is the use of Select transformation

Select Transform output

RE: What is the use of Select transformation

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

RE: What is the use of Select transformation

Select Transform output

RE: What is the use of Select transformation

 

Expert Answered on June 8, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.