# Table Customizer not appearing

**URL:** <https://forum.inductiveautomation.com/t/table-customizer-not-appearing/7907>\
**Category:** Ignition\
**Created:** [January 27, 2014, 7:34pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-appearing/7907 "2014-01-27T19:34:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Damselfly](https://avatars.discourse-cdn.com/v4/letter/d/8491ac/32.png) [@Damselfly](https://forum.inductiveautomation.com/u/Damselfly)\
**Post date:** [January 27, 2014, 7:34pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-appearing/7907/1 "2014-01-27T19:34:14Z")

</div>

I have a new window and have added a table. The table data source is set to a SQL Query. The Query results in data and the Table shows the rows. When I click on the “Table Customizer”, nothing happens. In the table properties, the “Column Attributes Data” shows .

How can I show / edit the column attributes?

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [January 27, 2014, 7:42pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-appearing/7907/2 "2014-01-27T19:42:57Z")

</div>

Open the Table Customizer  
Click OK

The columnAttributesData should fill in now.

(Oh, sorry, I didn’t see that the Table Customizer is not opening. Try saving the project and re-opening?)

---

<div class="post-metadata">

**Author:** ![Damselfly](https://avatars.discourse-cdn.com/v4/letter/d/8491ac/32.png) [@Damselfly](https://forum.inductiveautomation.com/u/Damselfly)\
**Post date:** [January 27, 2014, 7:55pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-appearing/7907/3 "2014-01-27T19:55:05Z")

</div>

Saving / re-launching designer didn’t fix it. If I add a new table, with no data source, then click the “Table Customizer” it shows up no problem. As soon as I add my SQL and fill the table with the results, the table customizer will not open.

Here’s my SQL:

SELECT  
pmi.position as’Position’,  
ig.name as ‘IngName’,  
ig.unitpackage as ‘PackageWeight’,  
ig.uom as ‘PackageUOM’,  
pmi.unitpackageno as ‘PackagesRequired’,  
pmi.partialweightkg as ‘PackageRemainder’,  
pmi.weightkg as ‘TotalRequiredWeight’,  
pmi.lotnumberactual as ‘LotNum1’,  
pmi.lotnumber2actual as ‘LotNum2’,  
pmi.lotnumber3actual as ‘LotNum3’,  
pmi.unitpackagenoactual as ‘Lot1PackQty’,  
pmi.unitpackageno2actual as ‘Lot2PackQty’,  
pmi.unitpackageno3actual as ‘Lot2PackQty’,  
pmi.partialweightkg2 as ‘Lot2PartialPackQty’,  
pmi.partialweightkg3 as ‘Lot3PartialPackQty’

FROM  
productmixingredients pmi  
LEFT JOIN ingredients ig ON ig.id = pmi.ingredientid  
WHERE  
pmi.productmixid = 6853

I am using 7.6.4

Thanks for your help!

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [January 27, 2014, 11:31pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-appearing/7907/4 "2014-01-27T23:31:13Z")

</div>

You’re using the column name ‘Lot2PackQty’ twice, which will make the customizer throw an exception. You probably wanted to use the digit 3 in one of them.

For future info, when you have a problem like this, it’s usually a good idea to look at the console in the Designer. In this case, the console would give you a message about an illegal argument exception, and tell you the name of the duplicated column. Saves a lot of heartache. 🙂

---

<div class="post-metadata">

**Author:** ![Damselfly](https://avatars.discourse-cdn.com/v4/letter/d/8491ac/32.png) [@Damselfly](https://forum.inductiveautomation.com/u/Damselfly)\
**Post date:** [January 28, 2014, 2:40pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-appearing/7907/5 "2014-01-28T14:40:36Z")

</div>

Hi!

That did it… I’ll keep an eye on the output console… didn’t realize that it’s the location that shows errors like that… I would have expected some kind of pop-up message when the table customize failed to load.

Thanks! 😃