DS Job design logic

[kksr]

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

[ray.wurlod]

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.