# Lookup Tables in Transformation Lite

**URL:** <https://forum.cloverdx.com/t/lookup-tables-in-transformation-lite/288>\
**Category:** CloverDX Platform\
**Created:** [March 3, 2008, 12:00am UTC](https://forum.cloverdx.com/t/lookup-tables-in-transformation-lite/288 "2008-03-03T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bijkler](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/bijkler/32/81_2.png) [@bijkler](https://forum.cloverdx.com/u/bijkler)\
**Post date:** [March 3, 2008, 12:00am UTC](https://forum.cloverdx.com/t/lookup-tables-in-transformation-lite/288/1 "2008-03-03T00:00:00Z")

</div>

Is it possible to use the contents lookup table in a REFORMAT transformation using only a Transformation Lite script.

- Mat

---

<div class="post-metadata">

**Author:** ![jurban](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jurban](https://forum.cloverdx.com/u/jurban)\
**Post date:** [March 3, 2008, 1:42pm UTC](https://forum.cloverdx.com/t/lookup-tables-in-transformation-lite/288/2 "2008-03-03T13:42:35Z")

</div>

Hi,  
yes it is possible by using the Lookup Join component. Just specify that you want to read from the 1st source, not from the 0th. For example:

${in.1.lastName}

The code above reads the “lastName” field of the lookup table.

Jaro
