Create columns from a SQL Column

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

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
GROUP BY Description
ORDER BY Description

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

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