Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 1,441 Topics
  • 3,408 Replies
1440 Topics
Saba
Level 3
SabaLevel 3
asked in General Product Q&A
Merge or Combine

Hello Everyone,In my View, some numbers appear twice — one row contains lead time and price for version A, and the other row contains lead time and price for version B.So for a specific number, you either see data for version A or version B, but I want to combine them into a single row for that number.Here’s an example of how my data looks now:Number Lead Time A Lead Time B Price A Price B 12345 28 - 10.88 - 12345 - 7 - 6.94 And this is what I want to get:Number Lead Time A Lead Time B Price A Price B 12345 28 7 10.88 6.94 Is there a way to do this?Thanks a lot!

897
abhishek.chatu14
Level 7
Saba
Level 3
SabaLevel 3
asked in General Product Q&A
Duplicate

Is there a way to remove duplicate values in a coloumn ? 

101
Sverre Klein
Level 6
robert.ledig
Level 2
robert.ledigLevel 2
asked in General Product Q&A
Difference between CASE WHEN and STATIC CASE WHEN and when to use it?

Hello everyone,I hope you can help me understand the difference between the two PQL functions CASE WHEN and STATIC CASE WHEN.I can't find the difference using the documentation, and unfortunately, I couldn't find any content about it in the forum either. I would really appreciate your help and hope someone can explain it.Thank you for your support!Best regards,Robert

262
robert.ledig
Level 2
antonio.figue
Level 2
antonio.figueLevel 2
asked in General Product Q&A
Create and send automated PDF reports from Views

Hi, I currently have a dashboard in Studio Analysis for which I built an Action Flow that picks up a distribution list with certain filters so that i can send out automated emails with a pdf attachment (each with different filters). Now I wanted to do the same with a View and this is not possible.50 users should receive an automated pdf of a View on a weekly basis filtered only on their set of Divisions/ Product Groups. What is the best alternative to automate this?BR  

80
antonio.figue
Level 2
stephan.kosch
Level 2
stephan.koschLevel 2
asked in General Product Q&A
Line Break in Tables

Hello everyone, have you thought about integrating line breaks into Tables of the new views? Can you please give us a brief update on this.Thank youStephan

201
A
Celonaut
thomas.keim
Level 3
thomas.keimLevel 3
asked in General Product Q&A
Check if a Variable (New Views) is null

Hello Community,how can I check if a variable from the new views is NULL? My challenge is to not use an filter in a PU_FUNCTION when the variable is empty.Variable: VAR_CONDITION_FILTERExample Value with multiple selection: ‘Y001’, ‘Y020’, ‘Y300’I want to use the variable in a PU_SUM Filter statement like in this way.PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", CASE WHEN '${var_condition_filter}' IS NOT NULL THEN "FREIGHT"."CONDITION" IN (${var_condition_filter}) END )But this don’t work. Error:A PQL error is preventing this query from executing.Syntax error near [IN] after reading [PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", CASE WHEN '${var_conditon_filter}' IS NOT NULL THEN "FREIGHT"."CONDITION" ] at line 9. Please refer to PQL documentation for available syntax. This here works, but I need the check if the variable is empty to avoid errors and to avoid that users has to select all the possible values.PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", "FREIGHT"."CONDITION" IN (${var_c

210
thomas.keim
Level 3
carmen.kaluz
Level 2
carmen.kaluzLevel 2
asked in General Product Q&A
How can I use the List Items - Microsoft SharePoint Online in Action Flow module to read records that exceed the limit of 3500?

Hey everyone, I have created an Action Flow with the List Items - Microsoft SharePoint Online module to read data from a SharePoint site that contains more than 3500 records.I wanted to know if there is any way to read records from SharePoint that exceed the limit of 3500 and how to configure this (e.g. using the Repeater module) ?  

633
abhishek.chatu14
Level 7
nicolas.kazek
Level 2
nicolas.kazekLevel 2
asked in General Product Q&A
Restrict Scope of People for Task Assignment

Hi,we are looking for an option to restrict the dropdown of an “Asignee” component to a selected number of persons. Currently the dropdown shows ALL persons / groups in our tenant (see example below): Is it possible to restrict the dropdown to display only pre-defined users or user groups? If so, how can this be achieved?BR,

243
janpeter.van.d
Level 8
Andreas Siebler
Level 2
Andreas SieblerLevel 2
asked in General Product Q&A
Array aggregator can't read two bundles from Get Row module

Hi everyone, I have a question regarding Action Flow. I use a Get Rows module and get two bundles as a Output. Once I wanna use the two bundles in a further module within the Action Flow, I cannot select any of my columns I defined in my Get Rows module. The only columns I can select is “Total number of bundles”, “Bundle order position”, “undefined”. I haven’t found any documentation or similar issues in the community. If anybody has an idea how I can select my defined columns highly welcome to respond. Thank youAndreas

141
Andreas Siebler
Level 2
kiranmayi.kadim
Level 2
kiranmayi.kadimLevel 2
asked in General Product Q&A
facing issue while creating dropdown

Hi Team,I am facing issue while creating dropdown, I have used below PQL QueryCASE WHENRUNNING_TOTAL(SUM("PO_LINE_ITEM"."NET_VALUE_LINE_ITEM_IN_REPORTING_CURRENCY")) /GLOBAL(SUM("PO_LINE_ITEM"."NET_VALUE_LINE_ITEM_IN_REPORTING_CURRENCY")) <= 0.8 THEN 'Top 20% Vendors' ELSE 'Remaining Vendors'ENDwhile using this query in the dropdown i am getting only one option either 'Top 20% Vendors' or  'Remaining Vendors' but i want both the options in the dropdown. So pls kindly revert ASAP.Thanks,Kiranmayi

335
kiranmayi.kadim
Level 2
anusuya.ponnu
Level 3
anusuya.ponnuLevel 3
asked in General Product Q&A
Does Celonis have prebuilt apps for Tax reconciliation based on General Ledgers

Hi Team, Has anyone built solution for Tax reconciliation analysis based on General Ledgers for Indirect Tax. We are trying to automate tax reconciliation which will have analysis basis documents types, credit, debits for each GL account. Any suggestion on the SAP tables, logic are welcome.

443
S
Level 3
thomas.keim
Level 3
thomas.keimLevel 3
asked in General Product Q&A
Checking for existing table/view in Transformation

Hello Community,i have the challenge to extract and transform data from various SAP System und to combine them.My problem is, that there are tables who are filled or not depending on the system. If not filled, there is also no table in the schema. So I get an error while running the SQL script.My question: Is there an option to check with the SQL script if the table exists or not.In my example below: How to check if TABLE1 is existing or not. If yes all fine, if no only run the TABLE2 part.Thank youThomas CREATE VIEW TEST_VIEW ASSELECT"TABLE1"."MANDT" AS MANDT,"TABLE1"."TKNUM" AS TKNUM,"TABLE1"."TSNUM" AS TSNUMFROM "TABLE1"UNION ALLSELECT"TABLE2"."MANDT" AS MANDT,"TABLE2"."TKNUM" AS TKNUM,"TABLE2"."TSNUM" AS TSNUM,FROM "TABLE2" 

261
abhishek.chatu14
Level 7
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
Is there any way to implement custom objects in new view

I want to create an Aging/Market custom objects so my graph can be change based on dropdown I will select. let say If you select Aging then aging should be applied on the chart.  How to implement in new views?

254
kailash.potha12
Level 5
kailash.potha12
Level 5
kailash.potha12Level 5
asked in General Product Q&A
Excel Or CSV Exports

Hello,Is there an effective method to restrict exports to specific users or groups of users in Old Views?

200
kailash.potha12
Level 5
Nikhil
Level 2
NikhilLevel 2
asked in General Product Q&A
Automating the process of e-filing

Can I automate the process of doing UCC e-filing on a state website through setting up an Action flow or any other fearure present in Celonis?

130
Nikhil
Level 2
sunil.rai12
Level 2
sunil.rai12Level 2
asked in General Product Q&A
The Data Model Load experienced an issue with the Data Pipeline Orchestrator

Hi All,I’ve following error message when trying to reload the OCPM data model: The Data Model Load experienced an issue with the Data Pipeline Orchestrator. Celonis Support ID: 22950f46-9f10-46af-96de-887c2e2d81a5 Does anyone know what could be the issue here? Thanks,Sunil

262
sunil.rai12
Level 2
shaif
Level 3
shaifLevel 3
asked in General Product Q&A
Oracle EBS Tables for ORder to cash and Inventory

Dear all , Is there a handy reference for Oracle EBS tables related to procurement , order management and inventory for process mining ? 

40
shaif
Level 3
Akshay Haridas
Level 3
Akshay HaridasLevel 3
asked in General Product Q&A
Looping in vertica SQL in celonis transformations.

Hi All,I wanted to know if there is any way to implement looping concept in vertica SQL in celonis. I have a use case where I have to compare two tables on the basis of a certain date type column and this comparison must be done for every month in the data type column. So, in this scenario I wanted to use the looping concept as in other coding languages like python.Thank you in advance,Akshay

487
matt.witty13
Level 5
lyzanne.tr24
Level 2
lyzanne.tr24Level 2
asked in General Product Q&A
Time For Action Flow

Hello fellow Celonis users, I am trying to create a snooze function for my clients so that certain data will not be taken into account for analysis for the snooze set amount of time. I was wondering if it was possible to set a timer on an Action flow so that could be made possible or if you would suggest taking a different route? thank you in advance

153
A
Celonaut
daniel.magal
Level 2
daniel.magalLevel 2
asked in General Product Q&A
It is possible to create a table whose feed is variables that perform operations such as counting

It is possible to create a table that is filled with defined variables that count certain tasks.You see, in my organization we have 2 people responsible for the tasks, which would be the User and the Supplier. The User is responsible for 3 tasks and the Supplier for another 2, so I would like to make a table that appears Responsible   #Quantity of tasks completedUser                       30Supplier                   5 I can only add them as a columnCOUNT (DISTINCT CASE WHEN "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] Estado de la tarea" like 'Approved' OR "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] Estado de la tarea" like 'Reviewed'and "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" like 'Revisión Usuario' THEN "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" ELSE   NULL END )

111
ayushi.chakr11
Celonaut
denise.kruge12
Level 4
denise.kruge12Level 4
asked in General Product Q&A
PQL for case with minimum cycle time

Good morning, can someone please help with the PQL to return the case with the minimum cycle time? Thank you. Denise

50
denise.kruge12
Level 4
junwei.chai
Level 3
junwei.chaiLevel 3
asked in General Product Q&A
Action Flow scheduling to run at the end of fiscal month

Hi, I want to build an action flow that run at the end of the specific period based on the company period e.g. every month could be different October 23 is the end of the month and following month is end at November 27. How can I built this with Celonis built-in scheduling setting?? Thanks 

223
manuel.wetze
Level 4
junwei.chai
Level 3
junwei.chaiLevel 3
asked in General Product Q&A
Action Flow filter date

Hi,I want to create an action flow by querying a data within a specific range of date (e.g. total number of PO created from 01 November 2024 to 01 December 2024). How can I achieve that?    

444
junwei.chai
Level 3
frederick.coutr12
Level 3
frederick.coutr12Level 3
asked in General Product Q&A
Transformation Hub roadmap

Hi everyone,We’ve recently started trying the Transformation Hub, which looks like a fantastic tool for tracking the realization of value. While exploring its capabilities, we’ve noticed a few limitations (though we might be mistaken, as it’s still new to us).Is there a roadmap available that outlines when new features might be added? Specifically, we’re curious about the potential inclusion of:Custom processes Custom objective types Custom currencies (e.g., $CAD) Ability to track value based on something else than a financial amountThanks in advance for your guidance and any updates you can provide!

282
frederick.coutr12
Level 3
R
Level 2
rithu.kaLevel 2
asked in General Product Q&A
how to change the nanme

how to change the nanme

225
Kandregula Susmitha
Level 2

Badge winners

Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025