Hello, I have received the data set I want to analyze in several CSV files (due to the row limit of 1 million rows). Now I would like to merge this split CSV data set in Celonis, but I have not found the function to do so. The data set is structured in such a way that CaseID, Activity, Timestamp and other case information are each in one line, as can be seen in the screenshot. Thank you for your help.
Edit: Sorry for posting in the wrong category, it looks like it can't be changed.
Best answer by abhishek.chatu14
You can use the Union and Union ALL function for the same
DROP TABLE IF EXISTS BKPF_UNION;CREATE TBALE BKPF_UNION AS(SELECT *, epoch from BKPF_BSIK UNION ALL SELECT *, epoch from BKPF_BSAK);
+4You can use the Union and Union ALL function for the same
DROP TABLE IF EXISTS BKPF_UNION;CREATE TBALE BKPF_UNION AS(SELECT *, epoch from BKPF_BSIK UNION ALL SELECT *, epoch from BKPF_BSAK);
Thank you very much, that did the trick.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.