ニュース

GitHub3月

From SQL to SPL：Summarize row counts by dynamic columns into json

With Grouped AS ( SELECT td.hobbies_1, td.hobbies_2, COUNT(*) AS count FROM _temp_data td GROUP BY GROUPING SETS ( (td.hobbies_1), (td.hobbies_2) ) ) SELECT jsonb ...
GitHub3月

Azure Data Factory Project: Pivoting Sales Data (Rows to Columns)

This project demonstrates how to use Azure Data Factory (ADF) to transform Kaggle sales data by pivoting multiple product rows per transaction into a single wide row using Mapping Data Flows. Convert ...