Skip to main content

Celonis Product Documentation

Transformations
Create data transformation for the network table (Signal Link)

Go back to the “SAP O2C - Full Transformation” data job and create a new transformation called “Create Table: Shipment Network (Signal Link)”. Afterwards, perform the following intermediate steps:

  • Step 1: Insert the SQL script listed in Appendix C.

  • Step 2: Create transformation parameters for transport modes.

    Go to Parameters and create a transformation parameter for each of the four transport modes:

    Create a parameter with the name “Shipping_Type_Road”.

    image61.png

    Create a parameter with the name “Shipping_Type_Air”.

    image45.png

    Create a parameter with the name “Shipping_Type_Sea”.

    image62.png

    Create a parameter with the name “Shipping_Type_Rail”.

    image48.png

    In total, four transformation parameters should now have been created.

    image44.png

  • Step 3: Run the data job.