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 LC source column as 02
Output Format:
QTYNAME QTYVAL
GLTR 01
LTR 02
GLTR 03
LTR 04
Please help me for the above logic
_________________
job logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom