# Best way to display this table?

**URL:** <https://discourse.nodered.org/t/best-way-to-display-this-table/3720>\
**Category:** Dashboard\
**Created:** [5 October 2018 16:53 UTC](https://discourse.nodered.org/t/best-way-to-display-this-table/3720 "2018-10-05T16:53:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![seth350](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/seth350/32/4617_2.png) [@seth350](https://discourse.nodered.org/u/seth350)\
**Post date:** [5 October 2018 16:53 UTC](https://discourse.nodered.org/t/best-way-to-display-this-table/3720/1 "2018-10-05T16:53:41Z")

</div>

More of a HTML question than a Node-Red question..I suppose? 😔

I am receiving an object with multiple values from a Sql Server node.  
The object is structured as:

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/0/030bca698ca7e5f32702f5b4eb04834936c968e5.png)

I am able to put these values into a table using the ui-template node. I also use some of the values to insert the text into the SKU, UPC, and SKU Desc labels above the table.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/d/d1a962533f5f45066d01deed034c1c310e4a8a74.png)

With this HTML using two different templates:

```
<!--skuInfo Template--> 
     <div>
        <p id="skuNum">SKU#: {{msg.payload[0].SKU}}</p>
        <p id="upcNum">UPC#: {{msg.payload[0].UPC}}</p>
        <p id="skuDesc">SKU Desc: {{msg.payload[0].SKUDesc}}</p>
      </div>
<!--components Template-->
            <tr ng-repeat="(x,y) in msg.payload[0]">
            <td>{{ x }}</td>
          <td>{{ y }}</td>
        <td><i class="fa fa-times-circle fa-2x" style="color:red;"></i></td>
        </tr>

```

My issue is that, I need to filter out the SKU, SKUDesc, and UPC from the table, but allow it to be wrote to the labels above the table. I have been researching ng-repeat filters but I do not understand how to filter out my SKU, SKUDesc, and UPC entirely.

How would you suggest? Should this be filtered in the HTML or filtered by a node in between my sql node and the template node? How is that accomplished?  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/4/4fa7249f47e87a150d101f4fcea9c11f5b4703d2.png)

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [5 October 2018 21:56 UTC](https://discourse.nodered.org/t/best-way-to-display-this-table/3720/2 "2018-10-05T21:56:57Z")

</div>

maybe a change node in one of the paths set to delete payload[0].SKU and he other two you don't want.

---

<div class="post-metadata">

**Author:** ![seth350](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/seth350/32/4617_2.png) [@seth350](https://discourse.nodered.org/u/seth350)\
**Post date:** [6 October 2018 01:48 UTC](https://discourse.nodered.org/t/best-way-to-display-this-table/3720/3 "2018-10-06T01:48:10Z")

</div>

Thank you dceejay.  
I’m sorry, I admit...the obvious sometimes escapes me.