Solved

I need to take the first 8 values of a column to obtain the creation DATE. Then I need to take the remaining values for the TIME. I will then cast them as Date and Time for creating the EVENTTIME. The code below should have worked, but since it is a FLOAT data type I receive an error message on the Output. Code:SELECT ERSDA,ERSDA_TMSTP,SUBSTRING(ERSDA_TMSTP,0,8) AS "INFO1", SUBSTRING(ERSDA_TMSTP,9,4) AS "INFO2" FROM MCH1  Output:Execution error: ERROR: Function catalog.substring(float, int, int) does not exist, or permission is denied for catalog.substring(float, int, int)

According to requirement we have tried special character to identify but unable to add ' and % in celonis. The syntax which we have used is CASE WHEN("TABLE NAME"."COLUMN NAME") IN_LIKE ('!','@','#','$','^','*','(',')','- ','_','+','=','{','}','[',']','|','/',':',';','"','<','>',',','.','?') THEN 'CLEANSE' ELSE 'PERFECT' when we are adding ' and % two characters output is getting changed. For identifying the correct email address we have got this syntax IF(match_regex($email, '[a-zA-Z0-9_\\-]+@([a-zA-Z0-9_\\-]+\\.)+(com|org|edu|nz|au)', null))but its not working.

Hello All,   I want to use pycelonis to get all version of data pool (including Draft if present) The below code does not not show data pool version    data_pool = celonis.pools.find("XXXXXXXXXXXXXXXX) print (data_pool)  Output: <Pool, id XXXXXXXXXXXXXXXX, name 000_Extraction (000_CELONIS_DATA)>   Is there any way i could get the data pool versions? 

Hey there! I'm having trouble selecting cases from a table, that match a calculated condition.  The data I'm trying to analyse is about quality-checks. A quality-check consists of multiple rows in which the result (minor fault/major fault/no fault/not relevant) of each checkpoint is delivered. My goal is to calculate the quality of each quality-check and display those quality-checks which didn't reach a certain percantage of quality.  What I already did is: Calculate the quality of each check in %1- (SUM(STR_TO_INT(REMAP_VALUES("CASE_QS"."RESULT", ['no fault', '0'], ['minor fault', '5'], ['major fault', '10'], ['not relevant', '0']))) / (COUNT("CASE_QS"."CHECKPOINT")*10))Create condition to evaluate whether the desired quality of 99,9% isn't reachedCASE WHEN (1- (SUM(STR_TO_INT(REMAP_VALUES("CASE_QS"."RESULT", ['1', '0'], ['2&#3

Working with a dataframe activity table in Python I export the file in parquet format for efficiency reasons. However, when I load the file in Celonis it doesn't recognise the timestamp in the proper format but as a string. Can anyone tell me why this error is happening? Thank you very much. Thanks a lot.

Hi, I was looking through Celonis documentation but I cannot find the information were to find detailed Extractor Info. Uplink Integrations in Admin & Settings show only the connector version without details, while I'm looking for something like that: Thanks.

Date picker's SAP information is "AUFK"."ERDAT".Assuming 01,01,2022 for a,b,c and 31,12,2022 for d,e,f .

Hi all,I would like to know wheather celonis data job task have following features or not. 1. Code history feature to compare old to new code.2. Export all SQL on data job task, if #1 doesn't exist I'd like to store my SQL on my local.​Thanks and regards :) 

For example to calculate the share of items for each region. If I have an OLAP with all regions, I need to have the total number of items divided by the items for the region, but I want to have the total number dynamic to not update the total number manually.So the same output over all rows. Does someone knows how to do it?

 Imagine an activity table like this: Case 1 - Activity A - 1PMCase 1 - Activity B - 2PMCase 1 - Activity C - 3PMCase 1 - Activity D - 4 PM I want to aggregate on another column. I am using OLAP Table and my KPI is: Name: count of cases when Activity C happens < 2 hours from Activity B Formula:SUM(CASE WHENHOURS_BETWEEN(PU_FIRST(Cases,Eventtime,Activity=Activity B),PU_FIRST(Cases,Eventtime,Activity=Activity C)) < 2THEN 1ELSE 0END) When I run this against a list of all cases, I get the right answer 1, but when I aggregate it, I'm getting 4. I thought this would only evaluate once per case... is that incorrect?  Thanks,Matt

Sum(CASE WHEN "ActivityTable"."Activity" = 'something' THEN 1.0 ELSE NULL END) gives me the count when there is an entry "something" in the table.My challange is following: I need to count Distinct Case_ID, whenever "something" happens. It can happen more than 1 time for an Case_ID, so i need a PQL statement like:CASE WHEN "ActivityTable"."Activity" = 'something' THEN count (Distinct(Case_ID) ELSE NULL END, which is ofcourse not working like this. Ideas and solutions are welcome. Thanks a lot

Hi all,​I'd like to know where can I find prerequisites to use celoinis template in market place, which SAP table is required to use it, for example.should I need to check all SQLs or data connections to know it or do we have something Excel list to know it?

Hi all,​I have a problem about how to write PQL, please check following conditions and please let me know how to write it.​My process flow like thisProcess start(some activities here)work startwork start of A taskwork start of B taskwork start of C task(some activities here)Process end​and what I concern is #3 workstart, that has some branch and it might be in no particular order and combination is exist, so it might move 3-1 to 3-3 or 3-2 to 3-1, and I would like to get firstest work start time of work start. So I think it might be work if I can filter in specific activity name, then sort the date ascending and select distinct of its value but I don't know how to do it in PQL. Can anybody let me know how to do it?

Hi Expert,  Does anybody know how to export data model technical document as same as dashboard? I just would like to share how to connecting SAP add-on table to business side but there I don't found any connection export way other than json. (business side don't know tech except SAP so I need something natural language one is better.)  Do we have something way to export data model?

Dear Celopeer Hi. I would like to build a Concur Connection and extract data via the Concur API, but I couldn't find a Concur Connector (I think there used to be one, as described in this document SAP Concur Connection [Extractor Builder] (celonis.com)).Does anyone know how to connect to Concur via API?

Trying to find a transformation tasks where a particular table is used, right now going through each and every task its very time consuming effort.

Hi everyone,I am pretty new to Action Flows and currently I am trying to trigger an Action Flow by clicking a button in one of my analyses. Is this technically even possible? I couldn't find any fitting trigger modules in my Action FLow instance. Thanks in advanceFynn

How to calculate automation rate in PQL?

How to find number of rework activities with PQL?

Lets imagine I have a line graph. My KPI is order count. My dimension is the months of the year whose data comes from Table A's column B. So my dimension is ROUND_MONTH("A"."B") Which filter I need to add to see only the last month?

I'm trying to upload a file on Celonis, but i'm not being able to and when I try, the following message appears: I don't understand. What are the illegal characters in the target? Why can't I upload the file?

Have you ever used EKKO as a case table? What is the EKKO's activity table ?

Both the functions are used to retrieve rework, what is the difference ?

Hello,  I'm attempting to create a data connection via .xlsx file on my computer. I created a space and then made the data pool connection alias. However, once i select "Connect to Data Source" and successfully connect my data, it does not proceed to make the connection.  Can you please help and or instruct me on the correct method to complete the next steps? (See images below)  Once I selected Esc, the remains equivalent to image one, any help is greatly appreciated.  Thanks!!