# "Column 'col name' doesn't exist in this dataset" lookup expression binding errors upon initial opening of window

**URL:** <https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504>\
**Category:** Ignition\
**Created:** [October 8, 2020, 3:55pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504 "2020-10-08T15:55:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![rpavlicek](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rpavlicek/32/55868_2.png) [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\
**Post date:** [October 8, 2020, 3:55pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504/1 "2020-10-08T15:55:07Z")

</div>

I keep getting property binding errors: “Column ‘col name’ doesn’t exist in this dataset” upon initial opening of windows where I’m using a lookup expression binding reading from a dataset tag. It goes away after the initial error, but still is annoying. The column name does exist and the binding works as intended, is there anything I can do to correct this?

---

<div class="post-metadata">

**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\
**Post date:** [October 8, 2020, 3:58pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504/2 "2020-10-08T15:58:23Z")

</div>

Have you tried wrapping a try() around the lookup() function? ~~Or before that, have you configured a noMatchValue lookup parameter value?~~

Edit: noMatchValue is not an optional parameter.

---

<div class="post-metadata">

**Author:** ![rpavlicek](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rpavlicek/32/55868_2.png) [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\
**Post date:** [October 8, 2020, 4:14pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504/3 "2020-10-08T16:14:49Z")

</div>

Certainly the try would be good practice and I should probably be using this more. In this case, it would suppress the initial error and give it time to perform it’s binding function.

---

<div class="post-metadata">

**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\
**Post date:** [October 8, 2020, 4:19pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504/4 "2020-10-08T16:19:41Z")

</div>

That’s correct. I’m also curious if the dataset columns are different between the designer and runtime.

---

<div class="post-metadata">

**Author:** ![rpavlicek](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rpavlicek/32/55868_2.png) [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\
**Post date:** [October 8, 2020, 4:25pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504/5 "2020-10-08T16:25:38Z")

</div>

If I put in an index number instead of name, then the error doesn’t come up, but I prefer using the column name since the index could change at some point in time.

---

<div class="post-metadata">

**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\
**Post date:** [October 8, 2020, 4:39pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504/6 "2020-10-08T16:39:44Z")

</div>

I think this confirms what I’m thinking about the column name saved in the designer (assuming it’s not a tag).  
Could you explain what type of component is holding the dataset and how that dataset is populated?

---

<div class="post-metadata">

**Author:** ![rpavlicek](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rpavlicek/32/55868_2.png) [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\
**Post date:** [October 8, 2020, 5:18pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504/7 "2020-10-08T17:18:49Z")

</div>

The dataset is a memory tag and I’m usually using a custom property on a shape or power table component to use the lookup expression binding to read that tag, and returning either a single string or integer value.

---

<div class="post-metadata">

**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\
**Post date:** [October 8, 2020, 5:29pm UTC](https://forum.inductiveautomation.com/t/column-col-name-doesnt-exist-in-this-dataset-lookup-expression-binding-errors-upon-initial-opening-of-window/39504/8 "2020-10-08T17:29:40Z")

</div>

Ok, my assumption was wrong then. So now I find it odd there’s a different between colIndex and colName. I’d think the component hasn’t resolved the tagPath yet on initial opening of the vision window but that doesn’t seem to be the case. I’d just wrap a try around it and call it a day.
