LookupJoin Error

CloverDX Platform
1

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

2

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!

3

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