Process Mining Transformations — Part 8: Two Little Tricks

This is the 8th article in our series on typical process mining data preparation tasks. You can find an overview of all articles in the series here.

I picked up two little tricks from our customers that I thought could be useful for some of you as well. So, I am sharing them here. They are both related to the Windows command shell.

The first trick is from David. He showed me that you could open the command prompt in the path of the desired folder if you simply type cmd at the top of the folder window.

The second trick is from Maxime, who found out that you can join multiple data sets of the same shape by using the copy command in the following way:

copy /Y *.csv out\combinedfile.csv

You can watch the video above to see how I used both tricks to combine four separate data sets from January to April into one combined file. The combined file can then be imported into Disco.

Anne Rozinat

Anne Rozinat

Market, customers, and everything else

Anne knows how to mine a process like no other. She has conducted a large number of process mining projects with companies such as Philips Healthcare, Océ, ASML, Philips Consumer Lifestyle, and many others.