Engine / Editor
enhance_iwm_articles_textilkennzeichen_8
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
enhance
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
#get textilkennzeichen for all articles - group by selfdn #Connections Source_Config: enhanceEngine #config - credetials of source connection service Target_Config: enhanceEngine #config - credentials of target connection service #Engine Mode Engine_Mode: full Primary_Key: [ordernumber, firma, SELFDN] Enhance_Mode: flexible Datapool_Definition: ordernumber: VARCHAR(255) NOT NULL mainnumber: VARCHAR(255) DEFAULT NULL firma: VARCHAR(255) DEFAULT NULL textilkennzeichen: VARCHAR(255) DEFAULT NULL Source_Datapool: iwm_articles_textilkennzeichen_7 Target_Datapool: iwm_articles_textilkennzeichen_8 #Target Datapool: iwm_articles_textilkennzeichen_8 #sql table Sql: SELECT ordernumber, mainnumber, firma, '' as SELFDN, '' as SEKOMP, '' as SESTK1, '' as SESTO1, '' as SEPRZ1, '' as SESTK2, '' as SESTO2, '' as SEPRZ2, '' as SESTK3, '' as SESTO3, '' as SEPRZ3, '' as SESTK4, '' as SESTO4, '' as SEPRZ4, GROUP_CONCAT(textilkennzeichen SEPARATOR '<br>') as textilkennzeichen FROM iwm_articles_textilkennzeichen_7 GROUP BY ordernumber, mainnumber, firma Mapping: ordernumber: ordernumber mainnumber: mainnumber firma: firma textilkennzeichen: textilkennzeichen ordernumber: t1.ordernumber mainnumber: t1.mainnumber SELFDN: SELFDN SEKOMP: SEKOMP SESTK1: SESTK1 SESTO1: SESTO1 SEPRZ1: SEPRZ1 SESTK2: SESTK2 SESTO2: SESTO2 SEPRZ2: SEPRZ2 SESTK3: SESTK3 SESTO3: SESTO3 SEPRZ3: SEPRZ3 SESTK4: SESTK4 SESTO4: SESTO4 SEPRZ4: SEPRZ4
Definition aktualisieren