# Dataset bound Dropdown

**URL:** <https://forum.inductiveautomation.com/t/dataset-bound-dropdown/63689>\
**Category:** Ignition\
**Tags:** database, ignition81, perspective\
**Created:** [September 1, 2022, 5:09pm UTC](https://forum.inductiveautomation.com/t/dataset-bound-dropdown/63689 "2022-09-01T17:09:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![NII](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nii/32/12920_2.png) [@NII](https://forum.inductiveautomation.com/u/NII)\
**Post date:** [September 1, 2022, 5:09pm UTC](https://forum.inductiveautomation.com/t/dataset-bound-dropdown/63689/1 "2022-09-01T17:09:33Z")

</div>

I have a Dropdown that is bound to a two column dataset. Currently it only shows data from one column. How can I show both column with a space in between?

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [September 1, 2022, 5:18pm UTC](https://forum.inductiveautomation.com/t/dataset-bound-dropdown/63689/2 "2022-09-01T17:18:49Z")

</div>

You’d need to transform the binding being used.

The following code assumes the 0th column contains my “value” and the 1th column contains the “label”

```auto
def transform(self, value, quality, timestamp):
	options = []
	for i in range(0, value.getRowCount()):
		option_val = value.getValueAt(i, 0)
		option_label = str(option_val) + " " + str(value.getValueAt(i, 1))
		options.append({"value": option_val, "label": option_label})
	return options

```