DSXchange

Hi All,

I am designing one server job..

I have 2 columns from the source ( GL and LCL) which need to be loaded into target
Source Fields
GL LC
01 02
03 04
from the GL source filed I have load the data into target fields QTYNAME QTYVAL
For QTYNAME, I have to hard the value as GLTR and for QTYVAL, I have display from GL source column as 01

From the LC filed I have load the data into target fields QTYNAME QTYVAL
For QTYNAME, I have to hard the value as LTR and for QTYVAL, I have display from GL source column as 02
Output Format:
QTYNAME QTYVAL
GLTR 01
LTR 02
GLTR 03
LTR 04

Please help me for the above logic

Two outputs from Transformer stage, one for GL and one for LCL. Bring them together subsequently with an Aggregator stage.
I think you can figure out the column derivations.
Add a "key" column (derived as @INROWNUM) that you can use to re-unite the original rows.