enhance / enhance_iwm_articles_textilkennzeichen_8

#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