# How to get LookupTable into Reformat node's transformClass?

**URL:** <https://forum.cloverdx.com/t/how-to-get-lookuptable-into-reformat-nodes-transformclass/316>\
**Category:** CloverDX Platform\
**Created:** [May 16, 2008, 12:00am UTC](https://forum.cloverdx.com/t/how-to-get-lookuptable-into-reformat-nodes-transformclass/316 "2008-05-16T00:00:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![achan](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@achan](https://forum.cloverdx.com/u/achan)\
**Post date:** [May 16, 2008, 12:00am UTC](https://forum.cloverdx.com/t/how-to-get-lookuptable-into-reformat-nodes-transformclass/316/1 "2008-05-16T00:00:00Z")

</div>

Hi,

my graph looks like this:

\<?xml version="1.0" encoding="UTF-8"?\> 

the init() in myTranform class looks like this:

public boolean init(Properties props, DataRecordMetadata sourceRecordsMetadata, DataRecordMetadata targetRecordsMetadata) throws ComponentNotReadyException {

LookupTable lookup = getLookupTable(“lookup\_product\_types”);  
if (!lookup.isInitialized()) {  
lookup.init();  
}

System.out.println("lookup name : " + lookup.getName());  
System.out.println("lookup metadata : " + lookup.getMetadata());

…  
}

the output is:  
lookup name : null  
lookup meta data : null

how can I pass lookup\_product\_types to myTransform class so that I can perform DB lookup?

any help is greatly appreciated 🙂

Thanks,  
albert

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [May 19, 2008, 7:48am UTC](https://forum.cloverdx.com/t/how-to-get-lookuptable-into-reformat-nodes-transformclass/316/2 "2008-05-19T07:48:20Z")

</div>

Hi, your graph and transformation class are correct and should work properly. Only there is small bug in DBLookupTable that it doesn’t take into account the table name. If you write System.out.println("lookup id : " + lookup.getId()); in your transformation you get the correct ID.

---

<div class="post-metadata">

**Author:** ![achan](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@achan](https://forum.cloverdx.com/u/achan)\
**Post date:** [May 19, 2008, 4:07pm UTC](https://forum.cloverdx.com/t/how-to-get-lookuptable-into-reformat-nodes-transformclass/316/3 "2008-05-19T16:07:25Z")

</div>

Hi Agata,

How about lookup meta data? i am still getting “null”… i need the lookup meta data in my init() to setup the lookup key:

public boolean init(Properties props, DataRecordMetadata sourceRecordsMetadata, DataRecordMetadata targetRecordsMetadata) throws ComponentNotReadyException {

LookupTable lookup = getLookupTable(“lookup\_product\_types”);  
if (!lookup.isInitialized()) {  
lookup.init();  
}

System.out.println("lookup name : " + lookup.getName());  
System.out.println("lookup metadata : " + lookup.getMetadata());

String lookupKeyStr = {“lookup\_product\_type\_code”};  
RecordKey key = new RecordKey(lookupKeyStr, lookupMetadata);  
key.init();  
lookup.setLookupKey(key);

…

}

Thanks,  
al

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [May 20, 2008, 8:02am UTC](https://forum.cloverdx.com/t/how-to-get-lookuptable-into-reformat-nodes-transformclass/316/4 "2008-05-20T08:02:33Z")

</div>

Hi,  
it seems that there is one more bug in DBLookupTable and metadata in lookup table definition are discarded; they are created during first get method. But you need to set record key for the metadata, which you join with lookup table (as in graphDBLookup.grf:

```auto
		// create key 
	    String[] lookupKeyStr={"EmployeeID"};
		RecordKey key=new RecordKey(lookupKeyStr,sourceMetadata[0]);
		key.init();
		mylookup.setLookupKey(key);

```

)  
By the way for joining data with database could be better DBJoin or LookupJoin component.