# Value passing to params in table embedded dropdown not splitting

**URL:** <https://forum.inductiveautomation.com/t/value-passing-to-params-in-table-embedded-dropdown-not-splitting/92321>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [June 25, 2024, 11:02am UTC](https://forum.inductiveautomation.com/t/value-passing-to-params-in-table-embedded-dropdown-not-splitting/92321 "2024-06-25T11:02:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mmadariaga](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmadariaga/32/63201_2.png) [@mmadariaga](https://forum.inductiveautomation.com/u/mmadariaga)\
**Post date:** [June 25, 2024, 11:02am UTC](https://forum.inductiveautomation.com/t/value-passing-to-params-in-table-embedded-dropdown-not-splitting/92321/1 "2024-06-25T11:02:09Z")

</div>

I've followed [this tutorial](https://www.youtube.com/watch?v=xQiiJkSnrvg&ab_channel=ArtekIntegratedSolutions) to embed dropdowns in a table. In my case, I've got a multi-selection and a single-selection dropdown. The latter works fine, but for the multi-selection I don't know how to format the query to get the separated individual values for the _Referencias_ column. I've tried wrapping it in `[]` and leaving it as string with commas with no success.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/7/476bcd0fe5af5ac120c2f6f83635cd34735084d8.png)

---

<div class="post-metadata">

**Author:** ![mmadariaga](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmadariaga/32/63201_2.png) [@mmadariaga](https://forum.inductiveautomation.com/u/mmadariaga)\
**Post date:** [June 25, 2024, 1:45pm UTC](https://forum.inductiveautomation.com/t/value-passing-to-params-in-table-embedded-dropdown-not-splitting/92321/2 "2024-06-25T13:45:41Z")

</div>

I got it working by applying the following transform to the query binding which returns data in json. My refs keys contain values separated by commas.

```python
def transform(self, value, quality, timestamp):

	for item in value:
	    if 'refs' in item:
	        item['refs'] = [ref.strip() for ref in item['refs'].split(',')]
	return value

```

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/0/704cf10b6fd6911d3ef92bd0e3f2ad20d605829c.png)