Skip to main content

Celonis Product Documentation

ii. Without MLW script

Create a transformation "Create Table: EV_SUPPLIER_RATINGS" with the following query:

/*
Creates EV_SUPPLIER_RATINGS table from the integration_ids table from EcoVadis.
*/
DROP TABLE IF EXISTS EV_SUPPLIER_RATINGS;
CREATE TABLE EV_SUPPLIER_RATINGS AS (
   SELECT
     LPAD(integrations2.integration_ids,10,'0') AS integration_ids
     ,suppliers2.*
     ,ADD_MONTHS(suppliers2."published_date", 12) as expiration_date
   FROM "suppliers$integration_ids" as integrations2
   LEFT JOIN "suppliers" as suppliers2 ON 1=1
     AND integrations2."suppliers_evid" = suppliers2."evid"
     AND integrations2."integration_ids" != ''
);