# Lookup transform table options

**URL:** <https://developer.sailpoint.com/discuss/t/lookup-transform-table-options/81615>\
**Category:** SHF Discussion and Questions\
**Tags:** transforms, identity-security-cloud\
**Created:** [September 17, 2024, 7:18pm UTC](https://developer.sailpoint.com/discuss/t/lookup-transform-table-options/81615 "2024-09-17T19:18:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![josephcasale](https://avatars.discourse-cdn.com/v4/letter/j/fbc32d/32.png) [@josephcasale](https://developer.sailpoint.com/discuss/u/josephcasale)\
**Post date:** [September 17, 2024, 7:18pm UTC](https://developer.sailpoint.com/discuss/t/lookup-transform-table-options/81615/1 "2024-09-17T19:18:44Z")

</div>

Is it possible to generate the table values (not keys) dynamically in a transform?

For example:

```auto
{
  "attributes": {
    "table": {
      "512": "Austin",
      "281": "Houston",
      "214": "Dallas",
      "210": {
               "type": "substring",
                "attributes": {
                  "input": {
                    "type": "accountAttribute",
                    "attributes": {
                      "attributeName": "first_name",
                      "sourceName": "Example CSV Source"
                    }
                  },
                  "begin": 0,
                  "end": 1
             },
      "default": "Unknown Area"
    }
  },
  "type": "lookup",
  "name": "Lookup Transform"
}

```

---

<div class="post-metadata">

**Author:** ![anneragh](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/anneragh/32/8934_2.png) [@anneragh](https://developer.sailpoint.com/discuss/u/anneragh)\
**Post date:** [September 17, 2024, 7:38pm UTC](https://developer.sailpoint.com/discuss/t/lookup-transform-table-options/81615/2 "2024-09-17T19:38:53Z")

</div>

@josephcasale

Yes, you can read dynamically. I did this multiple times…!

To test, retrieve the accountAttribute just as below:

```auto
"210":{
       "attributes": {
                                "attributeName": "first_name",
                                "sourceName": "Example CSV Source"
                            },
                            "type": "accountAttribute"
}

```

Then apply a substring!

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [November 16, 2024, 7:39pm UTC](https://developer.sailpoint.com/discuss/t/lookup-transform-table-options/81615/3 "2024-11-16T19:39:06Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.