How to do a group by using the output as column header

Question

SELECT * FROM
(SELECT DISTINCT Invoice, Medical_Center, Year, Month FROM Denials_Scrub_Final) AS BaseData
Pivot (
COUNT(Invoice)
FOR Medical_Center
IN([BCHO], [UCSF],[UCD],[UCLA],[UCI],[UCSD])
)
AS PivotTable

------------------------------------

I need to do this in Alteryx

pivot alteryx.PNG

cmcclellan · Accepted Answer

I think this is what you're trying to do:

- a Summarize tool, with Invoice, Medical_Center, Year and Month as Group and Invoice as Count

- then a Cross Tab tool, grouping by all the columns above except;

* New Column Headers = Medical_Center
* Values for New Columns = Invoice Count

herbert1682 · Accepted Answer

This worked