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: unitizeEngine #config - credetials of source connection service
Target_Config: enhanceEngine #config - credentials of target connection service
#Engine Mode
Source_Datapool: tre_articles_stock_google_local
Enhance_Mode: flexible
#Engine Mode
Engine_Mode: full
Read_Conditions:
- articles_new.attr1 = 3
Joins:
- Right_Join: #each condition is joined with "AND"
Datapool: dg_supplierdata_enhanced.articles_new
Join_Condition: articles_new.ordernumber = tre_articles_stock_google_local.ordernumber
- Join:
Datapool: dg_supplierdata_enhanced.static_storeids
Join_Condition: static_storeids.firma = 3
Mapping:
store_code:
Source: static_storeids.storeid
ordernumber:
Source: articles_new.ordernumber
creation_date:
Source: articles_new.added
In_Export: no
itemid:
Source: articles_new.ordernumber
File_Field_Adapter:
Config: importEngine
Engine: importEngine
Datapool: trends_s_articles_details
Identifier: ordernumber
File: tre_articles_stock_google_local.itemid
Fields:
- ArticleId
- ArticleDetailsId
- ordernumber
price:
Source: tre_articles_stock_google_local.ordernumber #to be ignored
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
Cross_Field: price_EK #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
quantity:
Source: articles_new.ordernumber #to be ignored
File_Field_Adapter:
Engine: exportEngine
Datapool: export_articles_stock_tre
Identifier: ordernumber
File: tre_articles_stock_google_local.quantity
Fields:
- ordernumber
- stock_WIT
- stock_BOT
- stock_REC
- stock_HAA
- stock_LEV
availability: (0)
pickup_method: (0)
pickup_sla: (0)
Target_Datapool: tre_articles_stock_google_local
Filters:
- Filter:
name: DuplicateOrdernumber
condition:
Cross_Dataset_Filter_Adapter: filterByDuplicateOrdernumber
reason: 'There is another dataset with this ordernumber'
Metadata
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Source_Config | unitizeEngine |
|---|---|
| Target_Config | enhanceEngine |
| Source_Datapool | tre_articles_stock_google_local |
| Enhance_Mode | flexible |
| Engine_Mode | full |
| Read_Conditions | [ "articles_new.attr1 = 3" ] |
| Joins | [ { "Right_Join": null, "Datapool": "dg_supplierdata_enhanced.articles_new", "Join_Condition": "articles_new.ordernumber = tre_articles_stock_google_local.ordernumber" }, { "Join": null, "Datapool": "dg_supplierdata_enhanced.static_storeids", "Join_Condition": "static_storeids.firma = 3" } ] |
| Mapping | { "store_code": { "Source": "static_storeids.storeid" }, "ordernumber": { "Source": "articles_new.ordernumber" }, "creation_date": { "Source": "articles_new.added", "In_Export": "no" }, "itemid": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "Config": "importEngine", "Engine": "importEngine", "Datapool": "trends_s_articles_details", "Identifier": "ordernumber", "File": "tre_articles_stock_google_local.itemid", "Fields": [ "ArticleId", "ArticleDetailsId", "ordernumber" ] } }, "price": { "Source": "tre_articles_stock_google_local.ordernumber", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_tre", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "quantity": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "Engine": "exportEngine", "Datapool": "export_articles_stock_tre", "Identifier": "ordernumber", "File": "tre_articles_stock_google_local.quantity", "Fields": [ "ordernumber", "stock_WIT", "stock_BOT", "stock_REC", "stock_HAA", "stock_LEV" ] } }, "availability": "(0)", "pickup_method": "(0)", "pickup_sla": "(0)" } |
| Target_Datapool | tre_articles_stock_google_local |
| Filters | [ { "Filter": { "name": "DuplicateOrdernumber", "condition": { "Cross_Dataset_Filter_Adapter": "filterByDuplicateOrdernumber" }, "reason": "There is another dataset with this ordernumber" } } ] |