Return LookUp Value

CloverDX Platform
1

Hi,
I am trying to do a look up on a table (Product table, having columns Product_key,Product_code) using a code (say Product_code) coming from a input file.
After the lookup i want to return the primary key(Product_key).

Please tell me which component should i use. I tried using LookupJoin but i couldn’t find where do i specify the return value(Product_key).

Much Thanks,
Indu

2

Hello Indu,
lookup table serves as virtual port in LookupJoin component, so to refer the data use just notation as for 1st input port: $1.fieldName (see attached graph as example).

3

Hi Agata,

Tried to create a graph following your graph. The graph is running successfully but there are no outputs!
The data source field seems to be empty in your graph. Is that the problem that i am not getting the output??
Also the Data Source tab takes FileURL, is there any way that i can connect to the DB by giving connection details (like host name/username/password)?

Thanks,
Indu

4

Hello Indu,
you need to pre-fill the lookup table with data of course. You have a few possibilities:

  • use DBJoin instead of LookupJoin

  • use DBLookup instead of SimpleLookup
    In both above cases your query should look something like:
    select * from “Product table” where Product_code = ?

  • Pre-fill your lookup table with DBInputTable → LookupTableReaderWriter

5

Thanks Agata,
It worked with DBLookup :slight_smile: