Engine / Editor
export_lists_export_data
Mandant default
Pipelines
Engines
Include Mappings
Filter
Überblick
Editor
Validierung
Metadaten
Revisionen
Zurück
Altbestand
Engine bearbeiten
Bestand öffnen
Altbestand
Zum Editor
Run erst mit Status active
DRAFT
Status
engine
Typ
export
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
#Connections Source_Config: exportEngine #config - credetials of source connection service Target_Config: exportEngine #config - credentials of target connection service Mysql_Engine: InnoDB Default_Charset: utf8 #Source Source_Datapool: export_articles_tre #sql from Datapool_Definition: ordernumber: VARCHAR(20) NOT NULL attr1: VARCHAR(10) NOT NULL shipping_oms: VARCHAR(255) DEFAULT NULL shipping_oms_filtered: VARCHAR(255) DEFAULT NULL shipping_ost: VARCHAR(255) DEFAULT NULL shipping_tre: VARCHAR(255) DEFAULT NULL price_ost: VARCHAR(255) DEFAULT NULL price_tre: VARCHAR(255) DEFAULT NULL price_oms: VARCHAR(255) DEFAULT NULL filter_reason: VARCHAR(255) DEFAULT NULL filter_reason_oms: VARCHAR(255) DEFAULT NULL Sql: SELECT t1.*, export_articles_oms.attr8 as attr8_oms, export_articles_oms_filtered.attr8 as attr8_oms_filtered, export_articles_oms_filtered.filter_reason as filter_reason_oms, export_articles_oms.price_EK as price_oms, IF(t1.attr1=3,t1.price_EK,'') as price_tre, IF(t1.attr1=1,t1.price_EK,'') as price_ost FROM ( SELECT * FROM export_articles_ost UNION SELECT * FROM export_articles_ost_filtered UNION SELECT * FROM export_articles_tre UNION SELECT * FROM export_articles_tre_filtered ) as t1 LEFT JOIN export_articles_oms ON t1.ordernumber = export_articles_oms.ordernumber AND t1.attr1 = export_articles_oms.attr1 LEFT JOIN export_articles_oms_filtered ON t1.ordernumber = export_articles_oms_filtered.ordernumber AND t1.attr1 = export_articles_oms_filtered.attr1 #Mapping -> Mappings source fields are detected by Mapping Mapping: ordernumber: Source: t1.ordernumber attr1: Source: t1.attr1 Field_Adapter: - replace: [';', ''] shipping_oms_filtered: Source: attr8_oms_filtered shipping_oms: Source: attr8_oms File_Field_Adapter: File: export_lists_export_data.shipping_oms shipping_ost: Source: t1.attr8 File_Field_Adapter: File: export_lists_export_data.shipping_ost shipping_tre: Source: t1.attr8 File_Field_Adapter: File: export_lists_export_data.shipping_tre price_ost: Source: price_ost price_tre: Source: price_tre price_oms: Source: price_oms filter_reason: Source: t1.filter_reason filter_reason_oms: Source: export_articles_oms_filtered.filter_reason_oms #Target Datapool: export_lists_export_data #sql table Primary_Key: [ordernumber, attr1]
Definition aktualisieren