Engine / Editor
export_articles_properties_all_shops
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: enhanceEngine #config - credetials of source connection service Target_Config: exportEngine #config - credentials of target connection service #Source Source_Datapool: iwm_articles_properties #sql from Joins: - Join: #each condition is joined with "AND" Datapool: articles_new Join_Condition: iwm_articles_properties.ordernumber = articles_new.ordernumber AND iwm_articles_properties.firma = articles_new.attr1 Mapping: ordernumber: Source: iwm_articles_properties.ordernumber mainnumber: Source: iwm_articles_properties.mainnumber arte: Source: iwm_articles_properties.arte firma: Source: iwm_articles_properties.firma title: Source: iwm_articles_properties.title attr2: Source: iwm_articles_properties.attr2 attr3: Source: iwm_articles_properties.attr3 versandart: #attr13 Source: articles_new.attr13 anlieferart: Source: articles_new.anlieferart additional_properties: Source: iwm_articles_properties.additional_properties configuratorOptions: Source: iwm_articles_properties.configuratorOptions farbe_exakt: Source: iwm_articles_properties.farbe_exakt farbe: Source: iwm_articles_properties.farbe material: Source: iwm_articles_properties.material stil: Source: iwm_articles_properties.stil gewicht: Source: iwm_articles_properties.gewicht groesse: Source: iwm_articles_properties.groesse knuepfart: Source: iwm_articles_properties.knuepfart Breite: Source: iwm_articles_properties.Breite_ohne_Einheit Laenge: Source: iwm_articles_properties.Laenge_ohne_Einheit Hoehe: Source: iwm_articles_properties.Hoehe_ohne_Einheit Tiefe: Source: iwm_articles_properties.Tiefe_ohne_Einheit Durchmesser: Source: iwm_articles_properties.Durchmesser_ohne_Einheit abmessung: Source: iwm_articles_properties.abmessung funktion: Source: iwm_articles_properties.funktion Energiesparklasse: Source: iwm_articles_properties.Energiesparklasse # fuellung: # Source: iwm_articles_properties.fuellung ausfuehrungsart: Source: iwm_articles_properties.ausfuehrungsart bezug: Source: iwm_articles_properties.bezug massagefunktion: Source: iwm_articles_properties.massagefunktion Produkteigenschaften: Source: iwm_articles_properties.Produkteigenschaften PLPKAT: Source: iwm_articles_properties.PLPKAT Fassung: Source: iwm_articles_properties.Fassung Energieeffizienzklasse: Source: iwm_articles_properties.Energieeffizienzklasse Lichtstrom: Source: iwm_articles_properties.Lichtstrom Leistung: Source: iwm_articles_properties.Leistung Lebensdauer: Source: iwm_articles_properties.Lebensdauer Farbtemperatur: Source: iwm_articles_properties.Farbtemperatur Matratzenart: Source: iwm_articles_properties.Matratzenart Florhoehe_exakt: Source: iwm_articles_properties.Florhoehe_exakt Florhoehe: Source: iwm_articles_properties.Florhoehe Flaechengewicht_exakt: Source: iwm_articles_properties.Flaechengewicht_exakt Flaechengewicht: Source: iwm_articles_properties.Flaechengewicht Raum: Source: iwm_articles_properties.Raum Scheuertouren: Source: iwm_articles_properties.Scheuertouren Qualitaet: Source: iwm_articles_properties.Qualitaet IP: Source: iwm_articles_properties.IP Farbwechsler: Source: iwm_articles_properties.Farbwechsler Fernbedienung: Source: iwm_articles_properties.Fernbedienung Farbtemparatureinstellbar: Source: iwm_articles_properties.Farbtemparatureinstellbar Dimmbar: Source: iwm_articles_properties.Dimmbar fuer_fussbodenheizung_geeignet: Source: iwm_articles_properties.fuer_fussbodenheizung_geeignet Typ: Source: iwm_articles_properties.Typ Form: Source: iwm_articles_properties.Form Design: Source: iwm_articles_properties.Design Gesamtgewicht: Source: iwm_articles_properties.Gesamtgewicht Muster: Source: iwm_articles_properties.Muster Liegeflaeche: Source: iwm_articles_properties.Liegeflaeche Haertegrad: Source: iwm_articles_properties.Haertegrad Dessin: Source: iwm_articles_properties.Dessin Fuss: Source: iwm_articles_properties.Fuss Tischplatte: Source: iwm_articles_properties.Tischplatte Gestellfarbe: Source: iwm_articles_properties.Gestellfarbe Front: Source: iwm_articles_properties.Front Korpus: Source: iwm_articles_properties.Korpus Anschlag: Source: iwm_articles_properties.Anschlag Varianten: Source: iwm_articles_properties.Varianten Holzart: Source: iwm_articles_properties.Holzart Kissenbezug: Source: iwm_articles_properties.Kissenbezug Sitzschale: Source: iwm_articles_properties.Sitzschale Oberflaeche: Source: iwm_articles_properties.Oberflaeche Fussform: Source: iwm_articles_properties.Fussform Mass: Source: iwm_articles_properties.Mass Fussfarbe: Source: iwm_articles_properties.Fussfarbe Farbvariante: Source: iwm_articles_properties.Farbvariante Sitz: Source: iwm_articles_properties.Sitz Gestell: Source: iwm_articles_properties.Gestell Materialvariante: Source: iwm_articles_properties.Materialvariante Rueckenlehne: Source: iwm_articles_properties.Rueckenlehne Polsterung: Source: iwm_articles_properties.Polsterung Kontrastnaht: Source: iwm_articles_properties.Kontrastnaht Leder: Source: iwm_articles_properties.Leder Holzausfuehrung: Source: iwm_articles_properties.Holzausfuehrung Sitzhoehe: Source: iwm_articles_properties.Sitzhoehe Nahtart: Source: iwm_articles_properties.Nahtart Korpus_und_Arbeitsplatte: Source: iwm_articles_properties.Korpus_und_Arbeitsplatte Griff: Source: iwm_articles_properties.Griff Ruecken: Source: iwm_articles_properties.Ruecken Korpusbezug: Source: iwm_articles_properties.Korpusbezug Sitz_und_Kissen: Source: iwm_articles_properties.Sitz_und_Kissen Arbeitsplatte: Source: iwm_articles_properties.Arbeitsplatte Innenkorpus: Source: iwm_articles_properties.Innenkorpus Applikationsfarbe: Source: iwm_articles_properties.Applikationsfarbe Wangenform: Source: iwm_articles_properties.Wangenform Tischsaeule: Source: iwm_articles_properties.Tischsaeule Stauraum: Source: iwm_articles_properties.Stauraum Wendematratze: Source: iwm_articles_properties.Wendematratze Matratzenkern: Source: iwm_articles_properties.Matratzenkern Zonen: Source: iwm_articles_properties.Zonen Elektrische_Verstellung: Source: iwm_articles_properties.Elektrische_Verstellung Maximale_Belastbarkeit: Source: iwm_articles_properties.Maximale_Belastbarkeit Sitztiefenverstellung: Source: iwm_articles_properties.Sitztiefenverstellung Schlaffunktion: Source: iwm_articles_properties.Schlaffunktion Wall_Free: Source: iwm_articles_properties.Wall_Free Ruecken_echt: Source: iwm_articles_properties.Ruecken_echt Verstellbar: Source: iwm_articles_properties.Verstellbar Drehbar: Source: iwm_articles_properties.Drehbar Hoehenverstellbar: Source: iwm_articles_properties.Hoehenverstellbar Armlehne: Source: iwm_articles_properties.Armlehne Gestellmaterial: Source: iwm_articles_properties.Gestellmaterial Aufstehhilfe: Source: iwm_articles_properties.Aufstehhilfe Ausziehbar: Source: iwm_articles_properties.Ausziehbar Tischform: Source: iwm_articles_properties.Tischform Gestellform: Source: iwm_articles_properties.Gestellform prop1: Source: iwm_articles_properties.prop1 prop2: Source: iwm_articles_properties.prop2 prop3: Source: iwm_articles_properties.prop3 prop4: Source: iwm_articles_properties.prop4 prop5: Source: iwm_articles_properties.prop5 prop10: Source: iwm_articles_properties.prop10 prop11: Source: iwm_articles_properties.prop11 prop12: Source: iwm_articles_properties.prop12 prop50: Source: iwm_articles_properties.prop50 prop51: Source: iwm_articles_properties.prop51 prop52: Source: iwm_articles_properties.prop52 prop53: Source: iwm_articles_properties.prop53 prop60: Source: iwm_articles_properties.prop60 prop61: Source: iwm_articles_properties.prop61 prop62: Source: iwm_articles_properties.prop62 prop63: Source: iwm_articles_properties.prop63 prop64: Source: iwm_articles_properties.prop64 prop_status: Source: iwm_articles_properties.prop_status Filters: - Filter: name: DuplicateOrdernumber condition: Cross_Dataset_Filter_Adapter: filterByDuplicateOrdernumber reason: 'There is another dataset with this ordernumber due to selection from trends and ostermann' #Target Datapool: export_articles_properties_all_shops #sql table Primary_Key: [ordernumber]
Definition aktualisieren