Engine / Editor
export_quick_delivery_tre
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 Target_Config: exportEngine #Source Source_Datapool: export_iwm_tracking_tre Joins: - Left_Join: Datapool: export_iwm_orders_tre Join_Condition: export_iwm_tracking_tre.auftragsnummer = export_iwm_orders_tre.Auftragsnummer - Join: Datapool: mail_addresses_all Join_Condition: export_iwm_orders_tre.Kundennummer = mail_addresses_all.Kundennummer Read_Condition_Vars: - date = date("d.m.Y", strtotime('-0 days')) Read_Conditions: - export_iwm_tracking_tre.verkaufshaus = 97 - export_iwm_tracking_tre.versanddatum = %date% Mapping_Vars: shop: 'tre' Mapping: Include_Mapping_quick_delivery: quick_delivery Filters: - Filter: name: Delivery not within 3 days condition: Cross_Dataset_Filter_Adapter: export_orders_quick_delivery__filterSlowDelivery reason: 'Delivery not within 3 days' - Filter: name: DuplicateIdentifierBestellnummer #there must always be a space between the key and the comparision operator and between the parentheses condition: Cross_Dataset_Filter_Adapter: filterByDuplicateIdentifierBestellnummer reason: 'There is another dataset' - Filter: name: 'Name empty' condition: (Name == '') reason: 'Name empty' # - Filter: # name: 'Bestelldatum empty' # condition: (Bestelldatum == '') # reason: 'Bestelldatum empty' #Target Datapool: 'export_orders_quick_delivery_tre' Primary_Key: [Bestellnummer] # Bestelljahr: # Source: export_iwm_tracking_tre.ordernumber # Cross_Field_Adapters: # - Cross_Field_Adapter: # Config: exportEngine # Cross_Datapool: export_iwm_orders_tre #name of cross datapool # Cross_Field: Bestelljahr #field to select value from in cross datapool # Mapping: #cross field adapter with more than one key # ordernumber: Auftragsnummer # Bestellmonat: # Source: export_iwm_tracking_tre.ordernumber # Cross_Field_Adapters: # - Cross_Field_Adapter: # Config: exportEngine # Cross_Datapool: export_iwm_orders_tre #name of cross datapool # Cross_Field: Bestellmonat #field to select value from in cross datapool # Mapping: #cross field adapter with more than one key # ordernumber: Auftragsnummer # Bestelltag: # Source: export_iwm_tracking_tre.ordernumber # Cross_Field_Adapters: # - Cross_Field_Adapter: # Config: exportEngine # Cross_Datapool: export_iwm_orders_tre #name of cross datapool # Cross_Field: Bestelltag #field to select value from in cross datapool # Mapping: #cross field adapter with more than one key # ordernumber: Auftragsnummer
Definition aktualisieren