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

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. 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.

Here's an example using your scenario: choice_filter_example.xlsx (11.0 KB)

2 Likes