General Product Q&A

Action Flows - Configure an advanced Action Flow Choose your journey 1 Configure alternative routes 2 Apply filters and conditions

Community FAQ: How do I update my password? Answer:To update your password, go through the following steps: 1. Click on your profile picture on the top right corner2. Go to My Settings from the dropdown.3. Click on the option "Change Password". A prompt will appear to provide the current password and to enter a new one twice. Please leave a like if this information was helpful!

CASE WHEN SUBSTRING ( "VBAP"."MATNR", 0, 2 ) = '60' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 2 ) = '64' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '647731' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '664402' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '664403' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666161' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666162' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666931' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666986' then 'Yes' WHEN SUBSTRING ( "VBAP"."MATNR", 0, 6 ) = '666987' then 'Yes' WHEN SUBSTRING ( "

This is a PQL question: - I have three THROUGHPUT calculations working (I think) - I now want to have a COUNT column next to each. But: I am counting ACTIVITIES not CASES. How can I count cases, not activities/tasks?

Hello everyone!I want to send an Action Flow weekly that displays the material numbers that qualify for an automatic ordering process (this process can be triggered by editing the material master data). Since employees might choose not to edit the master data due to various reasons, the one material number for example will show up every week in the CSV that is sent via the AF. It could be possible that this repetitive sending of material numbers that should not be automatically ordered might negatively affect the acceptance of the AF. Here's my idea: does somebody have an idea how to add a timestamp of the initial sendout of the data rows in the CSV file? So, for example, if one material number was already sent out via the AF on the 1st of January, in the next runs of the Action Flow the 1st of January will be visible in an extra column, so employees could filter it easily to the current date.  Thank you so much! BRJulia Bauer

Hi Folks, I have a use case where it would be easiest solution to use COUNT Statement within the FILTER? However it is not possible. Do you have some tips for me? Thanks. B.

Hello Community, I've created an Action Flow in Celonis which contains an UI Path Component which Adds an Item to a Queue. WHen trying to test if I can actually add an Item to a test Queue I get the error "RuntimeError [400] An organization unit is required for this action."The user I'm using has all the necessary roles and permissions to edit a queue.Where can I define the Organization Unit Id?  Also, I tried using the "Make an API Call" with the Method Post and the URL "odata/Queues/UiPathODataSvc.AddQueueItem" but it gets the same error.  I am really thankful for your help!

The load failed: Load failed. Error Message: Table "XYZ" has 7,145,120,256 rows. The current limit is 5,000,000,000 rows. 

Hi All,We are trying to implement the machine learning model Linear Regression in our ML workbench, Can anyone suggest us in what all parts of celonis will it be useful or a business use case were we can implement it successfully.

Could you please explain what exactly is happening here. does that mean that for the mentioned tables complete data is not loaded?

Even after being added to a team, the dashboard created by my team is not getting updated on my profile.

Complete the statement. When creating a pie chart in Celonis, … A. ... at least two KPIs need to be selected. B. ... an endless amount of KPIs can be selected. C. ... only one KPI can be selected.

Hi, i want to make a button that connects dashbaord information (data got from KPIs) to an external URL , but i can only use variables. So, i want to know if is possible to use this data (KPIs) into my URL button.

We are plotting Dpo vs payment date and have a requirement to display the data of the selected time period in the chart. But we are not able to do it. We did try using dropdowns but only selected date data is displayed and not the period between the days.

How can I copy bookmarks from one analysis to another? We keep around 200 bookmarks shared across multiple users. All of these should now be migrated into a different dashboard inside another package. Is there any official method for such task?

Hi, Can you help us with a question, please? What standard does Celonis use for JSON calls via API? RAW or X-www-form-urlencoded? Could you cite examples of these configurations within Action Flows? Thanks

Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

Hi Everyone, I'm trying to create a table using ML workbench by using this code  pool = celonis.data_integration.get_data_pool(id_ = pool_id) pool.create_table( df = input_table,         table_name = table_name,         drop_if_exists = True,         force = True,        )While running this i'm getting PycelonisNotFoundError for my instance. Here is the attached screenshot for reference. 

 CASE WHEN (ROUND_DAY("PAYMENT_TABLE"."Payment registered date")) < PU_MAX(DOMAIN_TABLE("PAYMENT_TABLE"."CG Key"), "PAYMENT_TABLE"."Payment registered date", ROUND_DAY("PAYMENT_TABLE"."Payment registered date") IS NOT NULL)THEN ROUND_DAY("PAYMENT_TABLE"."Payment registered date") ELSE NULL END 

Hello, I have been facing some issues accessing the Asset Library. I fill in with my credentials but messages like this appear: "You do not have access to the Apex class named 'qsydFileExplorerController'." Can anyone tell me why and how to solve it? Thanks

Hi there!I've a problem using a variable in a formula of OLAP_TABLE.I've two variables (Interv_1, prueba_var1) text/replacement Type, with values:Interv_1=OTHERPrueba_var1=3 If i want to use it in a text component, with variable "prueba_var1" is OK, but if i use the Variable "Interv_1" i have a formula error. I don't understand why..... Thanks in advance    

Hi Everyone, Hope your all doing well, I want to create a table where the data stored in it will be values selected from the dropdown in the view. Please share any suggestion asap. Thanks, KANDI AJITH NAIDU.

Hi Everyone!. I have a query. How do I transfer entire production instance data to another instance?. If possible, please let me know asap.

Good afternoon,  We have an Action View configured that has a Send Email Action Flow attached that, for each record invoice code, will send an email to a Customer with information. To this end, we have been looking for a way to preview the email, via a click for example, so that you can view the specific email being sent and possibly make any changes.   How could we achieve this?   Thank you Maicol Munevar