Create columns from a SQL Column

Ignition
1

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
Capture205×858 4.01 KB

2

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:

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

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
image806×787 24.3 KB

4

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

5

Thanks!