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.
Page 1 / 1
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
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.