Merging CSVs

Question

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.

Page 1 / 1

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);

Thank you very much, that did the trick.

Reply

abhishek.chatu14 · Accepted Answer

You can use the Union and Union ALL function for the sameDROP TABLE IF EXISTS BKPF_UNION;CREATE TBALE BKPF_UNION AS(SELECT *, epoch from BKPF_BSIK  UNION ALL SELECT *, epoch from BKPF_BSAK);

michael.kohlm · Answer

Thank you very much, that did the trick.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN