Lookup Functions Error: Unexpected null value

yichuansancun

• January 19, 2015 00:00

• Answered

Follow

See attached graph. I am getting the following error:

    9:     $out.0.WD_Ref = lookup(Citizenship).get($in.0.c_country, $in.0.c_citizenship_status).WD_Ref_ID;
 
    ----------------------- CTL2 snippet -----------------------
     Unexpected null value.
----------------------------------------------------------------------------------------------------------
ERROR [main] - Execution of graph failed !

The 'WD_Ref_ID' has "^^^^^^^^^^" underneath it.

What did I do wrong :(

• Lookup Functions.grf

• 

  slechtaj

  • January 20, 2015 09:48

  0

  Comment actions Permalink

  Hi,
  
  could you please attach the whole project (including data sample).
  
  Thanks!
• 

  yichuansancun

  • January 20, 2015 19:52

  0

  Comment actions Permalink

  Here you go! Thanks!

  • LookupFunctions.zip
• 

  yichuansancun

  • January 20, 2015 22:47

  0

  Comment actions Permalink

  I solved the problems, I changed the code to the following and worked:
  
  

  if(lookup(Citizenship).get($in.0.c_country, $in.0.c_citizenship_status) == null)
  	{ $out.0.WD_Ref = "not found";}
  	else 
  	{
  	$out.0.WD_Ref = lookup(Citizenship).get($in.0.c_country, $in.0.c_citizenship_status).WD_Ref_ID;}

• 

  dpavlis

  • January 21, 2015 10:44

  0

  Comment actions Permalink

  You can also use CTL's conditional fail expression.
  
  The code would look like this:
  

  
  $out.0.WD_Ref = lookup(Citizenship).get($in.0.c_country, $in.0.c_citizenship_status).WD_Ref_ID : "not found";
  

Please sign in to leave a comment.