Here we have a scenario to get the below mentioned output from the given input. Let us see how to solve this scenario :
Input
Employee name Basic DA HRA MedicalA FoodA
John 5000 200 1000 500 500
George 6000 100 800 500 200
Carol 3000 700 700 800 900
Output Required :
Employee name Salary_type Salary_Amt
John Basic 5000
John DA 200
John HRA 1000
John MedicalA 500
John FoodA 500
George Basic 6000
George DA 100
George HRA 800
George MedicalA 500
George FoodA 200
Carol Basic 3000
Carol DA 700
Carol HRA 700
Carol MedicalA 800
Carol FoodA 900
Answer :
1) The input from the Source has to be connected to Normalizer transformation .
2) In the normalizer transformation we will get two outputs ., One is Employee name and other is the Amount. The GCID number is also generated , which will give the salary type.
3) In this way the normalizer transformation generates transpose of the input(table).
4) The output from normalizer can be given to an expression transformation to get the Salary type which can be generated from GCID number.
It will be like
Employee name GCID Salary_Amt
John 1 5000
John 2 200
John 3 1000
John 4 500
John 5 500
George 1 6000
George 2 100
George 3 800
George 4 500
George 5 200
Carol 1 3000
Carol 2 700
Carol 3 700
Carol 4 800
Carol 5 900
4) Its an active transformation and the reverse of aggregator transformation which reduces the number of output.
In this way we can get the above output
