Find Total_Score and Percentage using Transformer Stage

If we have a data as below

x_Comp

e_id,e_name,s_1,s_2,s_3,s_4,s_5
100,kelvin,35,40,50,49,60
200,rudd,40,80,60,55,56
300,emy,65,50,35,45,60
400,lin,30,45,60,60,55
500,jim,34,40,60,70,55


We are going to find Total_Score and Percentage using Transformer Stage

Take Job Design as

Seq.File--------------Tx ----------------------D.s



Read and load the data in Seq.File

In Transformer Stage Drag and Drop all the columns

Create two columns as Total_Score and Percentage

In total_score derivation write expression as

s_1+s_2+s_3+S_4+s_5

In Percentage Derivation write expression as

(s_1+s_2+s_3+s_4+s_5)/500 *100 Click OK


Give File name to the target file

Compile and Run the Job