Iam having a Source column name as N/A.I want to enter a hard coded value ab04 in the target column by name p_code.
How do i this?
RE:Hard Code Value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Tue Aug 01, 2006 1:37 am
- Location: Hyderabad
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 19
- Joined: Tue Aug 01, 2006 1:37 am
- Location: Hyderabad
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the Lookup stage you can return the lookup key. You can not assign (derive) values in output columns. Downstream, in a Modify or Transformer stage, test whether that returned key is null; if so, your lookup failed, otherwise your lookup succeeded. Of course, if your Lookup stage has a rejects link, you will only get the successful ones downstream on the main flow. Replace the null with your selected value. For example, in a Modify stage:
Code: Select all
outcol:string[4]=handle_null(keycol,"ab04")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.