# Dataview not creating the columns after selecting the table

**URL:** <https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417>\
**Category:** Kinetic ERP\
**Tags:** customization\
**Created:** [August 9, 2021, 8:15am UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417 "2021-08-09T08:15:43Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 9, 2021, 8:15am UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/1 "2021-08-09T08:15:43Z")

</div>

Hi  
I have created a dataview which uses the Part table, but after I have entered ‘Part’ for the ‘data’ and ‘server’ settings no columns are retrieved from the table.  
If someone can help me with this I would be very grateful.

Many thanks.

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [August 9, 2021, 12:05pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/2 "2021-08-09T12:05:33Z")

</div>

Can you share a screenshot of your view?

---

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 9, 2021, 12:10pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/3 "2021-08-09T12:10:44Z")

</div>

Hi  
Below is the screen shot of my data view, thanks.

 ![image](https://www.epiusers.help/uploads/default/original/3X/6/9/69b547a903ca58390728c1e294b88590fa590a29.png)

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [August 9, 2021, 12:40pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/4 "2021-08-09T12:40:24Z")

</div>

Do they appear if you save, exit App Studio, and go back in?

---

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 9, 2021, 12:42pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/5 "2021-08-09T12:42:42Z")

</div>

Hi  
No they don’t, I have tried to delete the view re-create as well as close the app.

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [August 9, 2021, 12:43pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/6 "2021-08-09T12:43:14Z")

</div>

After you type in “Part” under the Data.DataTable, do you see the loading bar attempting to retrieve information?

 ![image](https://www.epiusers.help/uploads/default/original/3X/4/e/4e1fb3257c1266bd022be04dcdce36c27c9be8a1.png)

---

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 9, 2021, 12:46pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/7 "2021-08-09T12:46:13Z")

</div>

I don’t, I just tried deleting and re-type and nothing appears.

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [August 9, 2021, 12:46pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/8 "2021-08-09T12:46:37Z")

</div>

What happens if you try to create a view for another data table? Try OrderDtl.

---

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 9, 2021, 12:50pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/9 "2021-08-09T12:50:31Z")

</div>

That did create the columns as soon as I tabbed off the Data Table field.

---

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 9, 2021, 12:55pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/10 "2021-08-09T12:55:38Z")

</div>

I just tried again creating the view for the part table and it still doesn’t create the columns. Very strange!

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [August 9, 2021, 12:57pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/11 "2021-08-09T12:57:17Z")

</div>

Hmmm.  
If you have it as OrderDtl and save, then switch to Part, do you get this Info Message?

 ![image](https://www.epiusers.help/uploads/default/original/3X/7/0/70e363683aaf31bdda790c8e06e7266c02890146.png)

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [August 9, 2021, 12:57pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/12 "2021-08-09T12:57:57Z")

</div>

Also, what about a part-related table?  
Maybe try PartPlant or PartRev.

---

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 9, 2021, 1:02pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/13 "2021-08-09T13:02:19Z")

</div>

Hi  
This is odd!!!, I did what you said and changed it to PartPlant and it did create the columns, but then I changed it back to Part all the columns disappeared (as expected) but the Part columns again never appeared.

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [August 9, 2021, 1:02pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/14 "2021-08-09T13:02:58Z")

</div>

Huh. I would raise a support ticket for that one.

---

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 9, 2021, 1:03pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/15 "2021-08-09T13:03:42Z")

</div>

Ok, thanks for your help.

---

<div class="post-metadata">

**Author:** ![Ishkaran](https://www.epiusers.help/user_avatar/www.epiusers.help/ishkaran/32/37365_2.png) [@Ishkaran](https://www.epiusers.help/u/Ishkaran)\
**Post date:** [August 9, 2021, 5:32pm UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/16 "2021-08-09T17:32:49Z")

</div>

> [@pjmalpass](#):
>
> If someone can help me with this I would be very grateful.

This issue was fixed in 2021.1.5 / 100.5. What version of Kinetic are you using?

---

<div class="post-metadata">

**Author:** ![pjmalpass](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/57b2e6/32.png) [@pjmalpass](https://www.epiusers.help/u/pjmalpass)\
**Post date:** [August 10, 2021, 8:10am UTC](https://www.epiusers.help/t/dataview-not-creating-the-columns-after-selecting-the-table/81417/17 "2021-08-10T08:10:26Z")

</div>

Hi  
Many thanks for replying, my manager is going to look at the version and see if we can upgrade.

Thanks
