Skip to main content
Question

Mult two tables

  • September 17, 2020
  • 1 reply
  • 2 views
A
Level 5
Hi, I tried to build an OLAP table with les champs suivants : CHANGED_FROM : _CEL_P2P_ACTIVITIES.CHANGED_FROM CHANGER_TO : _CEL_P2P_ACTIVITIES.CHANGED_TO OverDelivery: EKPO.UNTTO UnderDelivery: EKPO.UEBTO I would like to create an column with CHANGED_FROM * OverDelivery But I received an error message. How could I do this multiplication between those tables ? image71463 2.27 KB image790124 6.4 KB Thanks in advance.

1 reply

C
Level 0
Hi Audrey, thank you for your question! The error message appears as you are multiplying a string input with a float which is not possible. In the standard P2P datamodel you should have the column CHANGED_FROM also in float format. This Column is called: _CEL_P2P_ACTIVITIES.CHANGED_FROM_FLOAT If you dont have this column you need to set it up by casting the respective input column as a float int the Event Collection. Hope this helps! Best regards, Celonis Data Science Team
Community Code of ConductAccessibility statement