Hi Everyone :), i have a list of all Customernumber in an Excel File, how can i import them into Celonis, so that i can use them for a Selection in an Analysis Sheet

Hi,

easiest way for a one time import is to make use of the "Upload Files" feature within Data Integration:

Uploading files (celonis.com)

In case this should be some sort a regular updated file that should get automatically updated you can do this via Action Flow (e.g Download File from Sharepoint) or via Machine Learning Workbench.

BR

Dennis

Where do i find the List, because if i look at the sources when creating a olap table, i can't find it

Hi,

first of all you need to upload you excel file into your data pool.

You can do this by going to Data -> Data Integration -> Select the Data Pool where you want to upload the file -> Data Connections -> Add Data Connection (upper right corner) -> Upload Files

There you can upload your excel file. I think this is really good explained in the video you can find on my provided link.

After that the excel file is available as a table within your data pool.

You can now make use of this data the same way as you know it from tables that have been extracted out of connected source systems. So in order to make it available within your analyses you have to add it to a transformation (e.g. join it within your logics and add the necessary columns into it) or just create a view of this new table and add it to your Data Model!

After that you will see the data / table in your analyses as you are used to it with other tables.

BR

Dennis

Hi, i created a view of it in the data model, but i still cant find it, how can i add it to a transformation. BR Louis

When you already added the table / view to the same data model that are used by your analyses you should be able to see it within your analyses after next successful complete data model load.

BR

Dennis

ok it works now, thanks a lot. One last question, is it possible to use more than the data model / knowledge model

Hi,

I am not sure if I understand your question.

You can use the uploaded file the same way as other tables within your data pool(s).

So you can make use of it within transformations etc. You add it to different data models / knowledge models.

You can make use of it within ML Workbench or Action Flows.

I mean for a analysis can i use there more than one data model, because i want to use the other tables aswell as the from one the excel file. Do i need to transform it then

It is not possible to use >1 data model per analysis.

You need to have a data model that includes all the tables you need for your use case.

This is typically been done within the data jobs -> data transformations where you create your Acitivity table, case table, relevant views (which also should contain your excel file).

Than you add all of those tables to one data model and maintain the relationships between the tables.

E.g connecting your case table with your excel file table.

After that you do a data model load and within your analyses have full access to all the tables connected within this data model.

Data Model Definition (celonis.com)

BR

Dennis