Legacy-Definition sicher vergleichen
Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.
Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.
Raw YAML
Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.
#Connections
Source_Config: enhanceEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service
#Source
Source_Datapool: articles_inhouse #sql from
Joins:
- Left_Join: #each condition is joined with "AND"
Datapool: iwm_articles_stock
Join_Condition: articles_inhouse.ordernumber = iwm_articles_stock.ordernumber AND articles_inhouse.attr1 = iwm_articles_stock.firma # One row per JOIN
- Left_Join:
Datapool: iwm_articles_properties
Join_Condition: articles_inhouse.ordernumber = iwm_articles_properties.ordernumber and articles_inhouse.attr1 = iwm_articles_properties.firma
Read_Conditions: #sql where - Read-Filter
- articles_inhouse.attr1 = 3 AND articles_inhouse.active_tre = 1
Mapping_Vars:
shop: 'tre'
inhouse_shop: 'tre_inhouse'
stammdaten_pool: 'articles_inhouse'
Mapping:
Include_Mapping_export_articles: export_articles_sw6
Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
- Include_Filter: price_EK_equals_0
- Include_Filter: channel_group_inhouse_shops
- Include_Filter: channel_trends_de
- Include_Filter: channel_trends_deaktivieren_csv
#Target
Datapool: export_articles_sw6_dev_instore_tre #sql table
Primary_Key: [ordernumber, attr1]
Metadata
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Source_Config | enhanceEngine |
|---|---|
| Target_Config | exportEngine |
| Source_Datapool | articles_inhouse |
| Joins | [ { "Left_Join": null, "Datapool": "iwm_articles_stock", "Join_Condition": "articles_inhouse.ordernumber = iwm_articles_stock.ordernumber AND articles_inhouse.attr1 = iwm_articles_stock.firma" }, { "Left_Join": null, "Datapool": "iwm_articles_properties", "Join_Condition": "articles_inhouse.ordernumber = iwm_articles_properties.ordernumber and articles_inhouse.attr1 = iwm_articles_properties.firma" } ] |
| Read_Conditions | [ "articles_inhouse.attr1 = 3 AND articles_inhouse.active_tre = 1" ] |
| Mapping_Vars | { "shop": "tre", "inhouse_shop": "tre_inhouse", "stammdaten_pool": "articles_inhouse" } |
| Mapping | { "Include_Mapping_export_articles": "export_articles_sw6" } |
| Filters | [ { "Include_Filter": "price_EK_equals_0" }, { "Include_Filter": "channel_group_inhouse_shops" }, { "Include_Filter": "channel_trends_de" }, { "Include_Filter": "channel_trends_deaktivieren_csv" } ] |
| Datapool | export_articles_sw6_dev_instore_tre |
| Primary_Key | [ "ordernumber", "attr1" ] |