you have to group by just the id columns and put functions on the rest of the columns you want. See below for solution. Yeah, it's tedious.select id, date, max(col1) as col1, max(col2) as col2, max(col3) as col3, max(col4) as col4
from table1
pivot (...
Hey guys,See here for a solution to this issue. You can specify the catalog when you setup the odbc driver.ODBC data source to connect to a Databricks catalo... - Databricks Community - 96354
