on 2025 May 12 8:12 AM
Dear all,
I have an existing dataset (Excel file) in SAP Analytics Cloud, and I would like to add another Excel file to it. Both files have the same column structure, and my goal is to combine them vertically — in other words, perform a UNION operation (as known from SQL), not a JOIN.
However, I’m struggling to find the right option to achieve this in SAC. I've gone through the menus, but there doesn’t seem to be a clear way to append the second file’s rows to the existing dataset.
Any guidance or step-by-step help would be greatly appreciated.
Thank you very much in advance, and I hope you're having a great day!
Best regards,
Justin
Request clarification before answering.
In this case, you can just load the new file with May 2025 data only into the same model by using the replace query option from data management, you can also reuse the data wrangling and mapping if the file has indentical structure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
24 | |
22 | |
8 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.