RE:Hard Code Value

m_siddu2000 · Post by **m_siddu2000** » Mon Oct 09, 2006 10:50 pm

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?

keshav0307 · Post by **keshav0307** » Mon Oct 09, 2006 10:54 pm

in the mapping by putting the hard code value, for that column

m_siddu2000 · Post by **m_siddu2000** » Mon Oct 09, 2006 11:15 pm

keshav0307 wrote:in the mapping by putting the hard code value, for that column

Iam unable to do that in the lookup stage?

Kirtikumar · Post by **Kirtikumar** » Mon Oct 09, 2006 11:27 pm

You can not do the hardcoding using lookup stage. Use transformer for that.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 10, 2006 2:11 pm

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")