# Local Data source

**URL:** https://community.thunkable.com/t/local-data-source/2714162
**Category:** Questions about Thunkable X
**Tags:** help
**Created:** [November 21, 2023, 4:03pm UTC](https://community.thunkable.com/t/local-data-source/2714162 "2023-11-21T16:03:17Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![dosantoss](https://avatars.discourse-cdn.com/v4/letter/d/d2c977/32.png) [@dosantoss](https://community.thunkable.com/u/dosantoss)
#### Post date: [November 21, 2023, 4:03pm UTC](https://community.thunkable.com/t/local-data-source/2714162/1 "2023-11-21T16:03:17Z")

</div>

Hello,

Can someone explain how to get a specific value with column as a variable in a local Data source, in the Drag-and-Drop version?

Here’s what I used in the StP version:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/0/a0a9cac231450674c66bbf6c10ea55e6859b09b7.png)

I’ve tried this on the DnD version, but it doesn’t work…

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/a/1ab4a4cbf0e1b6e546f8a9ffa5812203e1e9784a.png)

Thank you!

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [November 21, 2023, 8:05pm UTC](https://community.thunkable.com/t/local-data-source/2714162/2 "2023-11-21T20:05:15Z")

</div>

Are you trying to return a Row ID?

Can you give an example of your data source layout and how you would use this set of blocks if it did work?

---

<div class="post-metadata">

### Author: ![dosantoss](https://avatars.discourse-cdn.com/v4/letter/d/d2c977/32.png) [@dosantoss](https://community.thunkable.com/u/dosantoss)
#### Post date: [November 22, 2023, 10:03am UTC](https://community.thunkable.com/t/local-data-source/2714162/3 "2023-11-22T10:03:49Z")

</div>

I want to select a specific column that can vary, depending on the language chose by the user. Then select a value in this column.

Here’s an example:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/2/623e25e16a03fb418a7625c07113e015e101191a.png)

If the user select French as a language, I want to display game explanations in French.

It works well using the blocks of StP, but I don’t know how to proceed in DnD.

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [November 22, 2023, 4:01pm UTC](https://community.thunkable.com/t/local-data-source/2714162/4 "2023-11-22T16:01:46Z")

</div>

So you’re wanting to do a vlookup. There’s an example here that uses a green `item` block but you can just substitute “explanations” for that.

---

<div class="post-metadata">

### Author: ![dosantoss](https://avatars.discourse-cdn.com/v4/letter/d/d2c977/32.png) [@dosantoss](https://community.thunkable.com/u/dosantoss)
#### Post date: [November 22, 2023, 4:53pm UTC](https://community.thunkable.com/t/local-data-source/2714162/5 "2023-11-22T16:53:56Z")

</div>

That’s exatly it! Can you share the link or images of the example?

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [November 22, 2023, 7:06pm UTC](https://community.thunkable.com/t/local-data-source/2714162/6 "2023-11-22T19:06:09Z")

</div>

Sorry, I’m not sure why the url wasn’t included in my post. Here it is: [Performing a VLOOKUP in LocalDB - #28 by tatiang](https://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057/28)

---

<div class="post-metadata">

### Author: ![dosantoss](https://avatars.discourse-cdn.com/v4/letter/d/d2c977/32.png) [@dosantoss](https://community.thunkable.com/u/dosantoss)
#### Post date: [November 22, 2023, 8:55pm UTC](https://community.thunkable.com/t/local-data-source/2714162/7 "2023-11-22T20:55:25Z")

</div>

That was part of the solution, as I wanted both row and column to be variables.  
But watching your blocks just inspired me the solution I needed!

Thank you for your help Tatiang 👍

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [February 20, 2024, 8:55pm UTC](https://community.thunkable.com/t/local-data-source/2714162/8 "2024-02-20T20:55:53Z")

</div>

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