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 Mapping: Include_Mapping_export_articles: export_articles_inhouse Mapping_Vars: shop: 'tre' inhouse_shop: 'tre_inhouse' stammdaten_pool: 'articles_inhouse' Read_Conditions: #sql where - Read-Filter - articles_inhouse.attr1 = 3 AND articles_inhouse.active_tre = 1 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_tre_inhouse #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" } ] |
| Mapping | { "Include_Mapping_export_articles": "export_articles_inhouse" } |
| Mapping_Vars | { "shop": "tre", "inhouse_shop": "tre_inhouse", "stammdaten_pool": "articles_inhouse" } |
| Read_Conditions | [ "articles_inhouse.attr1 = 3 AND articles_inhouse.active_tre = 1" ] |
| 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_tre_inhouse |
| Primary_Key | [ "ordernumber", "attr1" ] |