@tomer1 (cc: @lary_andr ) The new data preparation experience feature in Quick Sight now provides advanced prep capabilities through a step-by-step visual interface. Going over this use case, you can first do a Pivot operation and then perform a left join on the result. Please try it out and let us know if you have questions.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Not getting data when we use left join | 9 | 65 | December 13, 2024 | |
| Pivot Table: Display rows with no values | 1 | 366 | August 2, 2023 | |
| Pivot Tables, Calculated Fields and Null Values | 4 | 225 | June 1, 2024 | |
| Dataset according to the pivot table | 3 | 32 | September 26, 2024 | |
| Showing 0s in pivot table for data that doesn't exist | 4 | 68 | May 7, 2025 |