Scenario 10: How to separate  the original records from source table to separate target table by using rank  transformation ?

Source Table

col1 col2 col3
a
b c
x y z
a b c
r f u
a b c
v f r
v f r

 

 

 

 

 

 

 

 

Target Table

Col1 Col2 Col3
a b c
x y z
r f u
v f r

 

 

 

 

 

Solution:
Step 1: Bring the source to mapping.

src to rank mapping

Step 2: Connect the rank to source.
Step 3: In rank, set the property like this.

rank property
Step 4: Then send it to target.
Run the session to see the result.