# Create columns from a SQL Column

**URL:** <https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682>\
**Category:** Ignition\
**Created:** [June 15, 2020, 10:59pm UTC](https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682 "2020-06-15T22:59:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![malejandroreyes](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\
**Post date:** [June 15, 2020, 10:59pm UTC](https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682/1 "2020-06-15T22:59:41Z")

</div>

How do I create new columns in Ignition from a SQL Column. SQL column contains different names, then I want to use those differente names to create headers and count how many times repeat those names. Column in SQL is Area

 ![Capture](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/6dd59b9f06ce081872c400c46adced7bbc0bc74b.png)

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 15, 2020, 11:16pm UTC](https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682/2 "2020-06-15T23:16:34Z")

</div>

Can you show an example of what you want as your result, using that screenshot?  
It sounds like you could just use a query to do this:

```auto
SELECT Description, Count(Description) as Count
FROM YOUR_TABLE_NAME
GROUP BY Description
ORDER BY Description

```

---

<div class="post-metadata">

**Author:** ![malejandroreyes](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\
**Post date:** [June 16, 2020, 2:16am UTC](https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682/3 "2020-06-16T02:16:54Z")

</div>

I made that procedure before, and it work for me, I can count all the description, but I can´t make the columns DIC, DOC, CMF. Desired result is this

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/412fc25785a13f712b285c09a08fceed54e2cbf7.png)

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 16, 2020, 2:18am UTC](https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682/4 "2020-06-16T02:18:14Z")

</div>

In that case, you’ll need to look into using a PIVOT:

> **[SQL Server PIVOT Operator Explained Clearly By Practical Examples](https://www.sqlservertutorial.net/sql-server-basics/sql-server-pivot/)**
>
> This tutorial shows you step by step how to use the SQL Server PIVOT operator to convert rows to columns.

---

<div class="post-metadata">

**Author:** ![malejandroreyes](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\
**Post date:** [June 16, 2020, 2:27am UTC](https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682/5 "2020-06-16T02:27:07Z")

</div>

Thanks!