Community

Recently active
Help others
Categories

Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables

I am using the free version and custom functionality.Have two event logs and trying to create two flows with transition using the process explorer.Data model, KM, Data Explorer everything is working. In the KM link between logs is enabled. In Views - Process explorer , it shows two flows. but the transition is not showing so trying to enable the configure transition in the Transition toggle and getting the error as Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables1.What should be data structure.?2.Do we need same event in both logs?3.How does multievent log works with Transition enabled in backend.

16 hours ago

emil.vakhi12Level 3

Process Improvement

Way to keep notification (performed via action flow) history and use it for filtering new notifications?

There is a case I want to solve, see below. I have a solution I would apply if I had classical programming language + RDBMS, but I'm not sure how to implement this in celonis or whether there is another solution. Could you please help? The case I want to solve is sending email notifications to users via action flow in case there are missing invoice receipts.For each missing invoice receipt there is a notification type that can be chosen with their own subjects, body text, etc., for instance:If the date1 >= today + 7 days then group 1.If the date1 >= today + 14days then group 2.If the due date >= today - 7 days then group 3. One possible solution would be to keep the history of the sent emails in some table and join it to the missing invoice receipts data to filter out the emails for each new iteration of sending - so that we don't send some letters twice if we already sent them.E.g. if we had sent the email of type for invoice receipt no. 12345 yesterday, we don't

113

1 day ago

MrAjLevel 3

General Product Q&A

Failed to auto save the View. Please save your changes manually

I'm encountering a persistent error in the View: "Failed to auto save the View. Please save your changes manually." Even when I attempt to save the changes manually, the View does not get saved, and none of the modifications to the UI are being retained. Is anyone getting the same issue? what could be the possible resolution?

222

1 day ago

lulzim.imeriLevel 2

Process Intelligence Graph (PI Graph)

Changing object colors in ocpm graph

Hi CommunityAny possibilities to change the object colors in an object centric graph?

172

2 days ago

Sony ShresthaLevel 2

Academy Q&A

Resolving Divergence in KPI Computation

I want to calculate KPI where I need to find number of Purchase Order where Invoice is created after payment creation. How can I write PQL query without getting result affected due to divergence? i.e I need to check for PO where invoice was created after payment creation for same invoice.

3 days ago

HsJaSeLevel 2

Process Analysis

Rework analysis

Hello,I am just starting with Celonis and I have the following question: I would like to find out which activities are repeated the most (rework). What could a corresponding PQL function look like? I have already looked at Calc_Rework and Index_Activity_Type, but both do not provide me with the right function because I would like to look at the rework number of activities across all cases (across all sales orders together) in order to make a statement about which activities cause the most rework in the company under consideration.Thank you very much in advance!

3 days ago

mccooleLevel 2

Celonis Free Plan

Why is Celonis Start for free disabled?

I was wondering why it is not possible to create a free account to be able to preview this solution. Thanks.

131

4 days ago

srikar.akell11Level 2

General Q&A

Is there a way to get the export of the data permissions

Hi, I want to know if there is a way to export the following listData model name ------ Data permissions ( Enabled/Disabled )if enabled then Group / User name ------ condition ( if any ) ----- unlimited (yes/no)i want to download this list as an excel, is it possible?

334

5 days ago

haruka.yanoLevel 2

Data Ingestion & Infrastructure

Object transformation preview once showed and disappers

HiI’m curently working on OCPM Data Pool and have trouble in an object transformation.In the Currecny Conversion object(o_celonis_CurrencyConversion),I checked that I can see data record in Preview,and executed publish to development.Then I ran the Data Job Transformation(full load), succeeded,ran the Data Model Load, succeeded,but at the end o_celonis_CurrencyConversion has no data.I don’t know why but when I go see the object preview again, the preview doesn’t show anything.Has anyone had this kind of experience ever?If yes please kindly help. FYI as the prerequisite, - the relevant sap table data is sycronized from another data pool - the object and its transformation script is celonis default one - Data job is done by the duplicate of test:ocpm-data-job(celonis default test data job) - the reason why I use the duplicate data job is that the original one returns an error for schema.

5 days ago

sayan.chakr12Level 3

General Product Q&A

I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task te

5 days ago

ClearnerLevel 2

Process Analysis

Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables

16 hours ago

lulzim.imeriLevel 2

Process Intelligence Graph (PI Graph)

Changing object colors in ocpm graph

Hi CommunityAny possibilities to change the object colors in an object centric graph?

172

2 days ago

Sony ShresthaLevel 2

Academy Q&A

Resolving Divergence in KPI Computation

HsJaSeLevel 2

mccooleLevel 2

Why is Celonis Start for free disabled?

I was wondering why it is not possible to create a free account to be able to preview this solution. Thanks.

131

4 days ago

srikar.akell11Level 2

General Q&A

Is there a way to get the export of the data permissions

334

5 days ago

haruka.yanoLevel 2

Data Ingestion & Infrastructure

Object transformation preview once showed and disappers

sayan.chakr12Level 3

.1460096356Level 2

Change the name to an event

Hi! I would like to personalize the event names for a client demo. How can we do it? Regards

5 days ago

gauri.pai11Level 2

Process Analysis

Table missing in new version of views

Hi team,I am working on creating a dashboard out of a table created by TASK(cel Task).I am able to find the table in legacy view but not in new view.Please find attached screenshot of legacy view and new view. Legacy view: New view:Can you please help me in this? Thanks and Regards,Gauri Pai

9 days ago

Welcome to the Community

Learn how to navigate the Celonis community and stay informed with the latest company updates.

Welcome Guide

4 topics

News & Updates

9 topics

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

Process Analysis

586 topics

Process Improvement

121 topics

Process Management

14 topics

AI

86 topics

Data Ingestion & Infrastructure

781 topics

Process Intelligence Graph (PI Graph)

33 topics

Celonis Free Plan

74 topics

General Product Q&A

1456 topics

Ask the Community

Get answers to general questions and Academy-related topics from fellow users and experts.

Academy Q&A

54 topics

General Q&A

1201 topics

User leaderboard

Badges

ebru.ulashas earned the badge Qualified to Get Data Into Celonis
aparna.ajith11has earned the badge Celonis Certified Data Analyst
erick.matoshas earned the badge Value Realization Expert
erick.matoshas earned the badge Qualified to Deliver Business Value with Celonis
irem.dinçhas earned the badge Qualified to Get Data Into Celonis

VIEW ALL

Explore the community

Join conversations, learn and grow with people who get community like you

Welcome to the Community

Welcome Guide

News & Updates

Product Q&A

Process Analysis

Process Improvement

Process Management

AI

Data Ingestion & Infrastructure

Process Intelligence Graph (PI Graph)

Celonis Free Plan

General Product Q&A

Ask the Community

Academy Q&A

General Q&A

User leaderboard

Badges

ANY QUESTION?

MORE CELONIS

CHECK US IN

Community

Explore the community

Join conversations, learn and grow with people who get community like you

User leaderboard

Badges

ANY QUESTION?

MORE CELONIS

CHECK US IN

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded