LookupJoin Error

pro7

• May 20, 2015 00:00

• Answered

Follow

Hi,
I'm trying to use a LookupJoin component in a graph. Port 0 data is from an xls reader. The lookup is a DB lookup. Join key is simple last name, first name. When graph runs it gets an error:


--------------------------------- Error details ----------------------------------
Component [LookupJoin:LOOKUP_JOIN] finished with status ERROR.
Error on field 'last_name'
Invalid column index
----------------------------------------------------------------------------------
ERROR [main] - Execution of graph failed !

Thanks

• 

  simaj

  • May 21, 2015 14:32

  0

  Comment actions Permalink

  Hi,
  
  Is it possible to share more details about the graph or better the whole graph ?
  
  

  
  What kind of lookup table is used ?
  LookupJoin attributes.
  Graph metadata.
  

  
  
  
  Thanks!
• 

  pro7

  • May 21, 2015 16:47

  0

  Comment actions Permalink

  Never mind...I was focused on the metadata and the sql but It looks like a problem with some of the data in the .xls.
  
  Thanks

Please sign in to leave a comment.