# How to get value from dataset in one column contains two values?

**URL:** <https://forum.getodk.org/t/how-to-get-value-from-dataset-in-one-column-contains-two-values/48501>\
**Category:** Support\
**Tags:** odk-xlsform\
**Created:** [July 31, 2024, 11:14am UTC](https://forum.getodk.org/t/how-to-get-value-from-dataset-in-one-column-contains-two-values/48501 "2024-07-31T11:14:39Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![danbjoseph](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/danbjoseph/32/21901_2.png) [@danbjoseph](https://forum.getodk.org/u/danbjoseph)\
**Post date:** [August 3, 2024, 4:57pm UTC](https://forum.getodk.org/t/how-to-get-value-from-dataset-in-one-column-contains-two-values/48501/2 "2024-08-03T16:57:46Z")

</div>

Welcome to the ODK forum, @Afrose_ahamed! We're glad you're here. When you get a chance, please [introduce yourself on this forum thread](https://forum.getodk.org/t/-/6671). I'd also encourage you to add a picture as your avatar because it helps build community!

I suggest reformatting your data table and using a [`choice_filter`](https://docs.getodk.org/form-logic/#cascading-selects).

Here's an example using your scenario: [choice\_filter\_example.xlsx](https://forum.getodk.org/uploads/short-url/ruNS6I2BYwYX262OVHhXjQxa0Hz.xlsx) (11.0 KB)

 ![Screenshot 2024-08-03 at 12.54.00 PM](https://getodk.b-cdn.net/uploads/default/original/3X/a/6/a68547562abf834110f372fdb409ead499aaeb6c.png) ![Screenshot 2024-08-03 at 12.54.11 PM](https://getodk.b-cdn.net/uploads/default/original/3X/c/8/c8b0ec8420fc4e9823209048eef525d782ae949d.png)

---

_[View the full topic](https://forum.getodk.org/t/how-to-get-value-from-dataset-in-one-column-contains-two-values/48501)._