# Assign multiple values using a lookup transform

**URL:** <https://developer.sailpoint.com/discuss/t/assign-multiple-values-using-a-lookup-transform/82608>\
**Category:** SHF Discussion and Questions\
**Tags:** transforms, identity-security-cloud\
**Created:** [September 23, 2024, 9:55pm UTC](https://developer.sailpoint.com/discuss/t/assign-multiple-values-using-a-lookup-transform/82608 "2024-09-23T21:55:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nick\_lubrano](https://avatars.discourse-cdn.com/v4/letter/n/dfb087/32.png) [@nick\_lubrano](https://developer.sailpoint.com/discuss/u/nick_lubrano)\
**Post date:** [September 23, 2024, 9:55pm UTC](https://developer.sailpoint.com/discuss/t/assign-multiple-values-using-a-lookup-transform/82608/1 "2024-09-23T21:55:53Z")

</div>

Hello, I have a use case where I need to assign multiple values to an attribute depending on the input. Represented as a lookup table, it looks something like this:

```auto
"table": {
	"1409": "209,214",
	"1414": "209,214",
	"800": "800",
	"1712": "005",
        "default": "NONE"
}

```

If the input is “1409” or “1414”, then the output should be “209” and “214”. Is this possible?

---

<div class="post-metadata">

**Author:** ![Mahesh\_Mukku](https://avatars.discourse-cdn.com/v4/letter/m/a698b9/32.png) [@Mahesh\_Mukku](https://developer.sailpoint.com/discuss/u/Mahesh_Mukku)\
**Post date:** [September 24, 2024, 5:24am UTC](https://developer.sailpoint.com/discuss/t/assign-multiple-values-using-a-lookup-transform/82608/2 "2024-09-24T05:24:49Z")

</div>

Hi @nick_lubrano ,  
Good Day!  
please check the below code we can achieve the output (209,214)

```auto
{
    "attributes": {
        "table": {
            "1409": "209,214",
            "1414": "209,214",
            "800": "800",
            "1712": "005",
            "default": "NONE"
        }
    },
    "type": "lookup",
    "name": "Lookup Transform"
}

```

---

<div class="post-metadata">

**Author:** ![sidharth\_tarlapally](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/sidharth_tarlapally/32/26178_2.png) [@sidharth\_tarlapally](https://developer.sailpoint.com/discuss/u/sidharth_tarlapally)\
**Post date:** [September 24, 2024, 6:15am UTC](https://developer.sailpoint.com/discuss/t/assign-multiple-values-using-a-lookup-transform/82608/3 "2024-09-24T06:15:50Z")

</div>

Hi @nick_lubrano ,

You cannot achieve this in the context of multi-valued attribute . But you can get a string value which is “219,214” , instead [129 , 214] . If my understanding is correct , you are trying to apply transform on a multi-valued attribute .  
You can see it the transforms documentation that the lookup transform’s key-value are of STRING type only , where as our usecase is to have array of strings.

 ![image](https://global.discourse-cdn.com/sailpoint/original/3X/a/5/a53ffc009918b4aede20b11a8139095ec38d106b.png)

For more information on this , refer to [LookUp Transform](https://developer.sailpoint.com/docs/extensibility/transforms/operations/lookup#:~:text=table%20%2D%20This%20is%20a%20JSON%20object%20of%20key%2Dvalue%20pairs.%20The%20key%20is%20the%20string%20the%20transform%20tries%20to%20match%20to%20the%20input%2C%20and%20the%20value%20is%20the%20output%20string%20the%20transform%20returns%20if%20it%20matches%20the%20key.)  
I hope this helps.  
Thanks

---

<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 23, 2024, 6:16am UTC](https://developer.sailpoint.com/discuss/t/assign-multiple-values-using-a-lookup-transform/82608/4 "2024-11-23T06:16:45Z")

</div>

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