Engine / Editor
unitize_suggestions_beny_all_marketplaces
Mandant csv-smoke
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
unitize
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
Engine: Unitize Source_Config: importEngine Target_Config: unitizeEngine Mysql_Engine: InnoDB Default_Charset: utf8 Source_Connection_Type: database Source_Database_Connection_Service: DatabaseConnectionService Source_Datapool: beny_suggestions_idealo Source_Primary_Key: [ID, SHOP, RANKING] Target_Primary_Key: [ID, SHOP, RANKING, MARKETPLACE] #always primary key for target datapool. primary key of source pool can be read from the pool itself. Datapool: beny_suggestions_all_marketplaces Datapool_Definition: MARKETPLACE: VARCHAR(50) NOT NULL FIRMA: VARCHAR(5) NOT NULL ARTE: VARCHAR(10) NOT NULL APNR: VARCHAR(10) NOT NULL ORDERNUMBER: VARCHAR(50) NOT NULL ID: VARCHAR(50) NOT NULL PRODUCTNAME: TEXT DEFAULT NULL CATEGORY: VARCHAR(255) DEFAULT NULL MANUFACTURER: VARCHAR(50) DEFAULT NULL MODEL: VARCHAR(50) DEFAULT NULL EAN: VARCHAR(50) DEFAULT NULL MPN: VARCHAR(50) DEFAULT NULL STATUS: VARCHAR(50) DEFAULT NULL RANKING: VARCHAR(50) NOT NULL SHIPPINGCOSTS: VARCHAR(50) DEFAULT NULL SHOP: VARCHAR(150) NOT NULL SHOP_URL: TEXT DEFAULT NULL NEWPRICE: VARCHAR(50) DEFAULT NULL OLDPRICE: VARCHAR(50) DEFAULT NULL PRICECHANGE: VARCHAR(50) DEFAULT NULL LASTUPDATE: VARCHAR(50) DEFAULT NULL BESTOFFERER: TEXT DEFAULT NULL BESTPRICE: VARCHAR(50) DEFAULT NULL TOTALPRICE: VARCHAR(50) DEFAULT NULL NEWTOTALPRICE: VARCHAR(50) DEFAULT NULL AVAILABILITY: VARCHAR(50) DEFAULT NULL DEEPLINK: TEXT DEFAULT NULL LISTED: VARCHAR(50) DEFAULT NULL CURRENTPRICE: VARCHAR(50) DEFAULT NULL AnbieterPreis: TEXT DEFAULT NULL #Sql: SELECT * FROM ( # SELECT t1.*, GROUP_CONCAT(CONCAT(CONCAT(t1.SHOP, ':'), t1.OLDPRICE) SEPARATOR ';') as AnbieterPreis, MAX(CAST(NEWPRICE AS DECIMAL(10,2))) AS MINNEWPRICE FROM ( # SELECT * FROM ( # SELECT 'idealo.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_idealo.* FROM beny_suggestions_idealo # UNION # SELECT 'google.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_google.* FROM beny_suggestions_google # ) as t0 # ) as t1 GROUP BY t1.MANUFACTURER, t1.MPN # ) as t2 Sql: SELECT t1.*, GROUP_CONCAT(CONCAT(CONCAT(t1.SHOP, ':'), t1.OLDPRICE) SEPARATOR ';') as AnbieterPreis, MAX(CAST(NEWPRICE AS DECIMAL(10,2))) AS MINNEWPRICE FROM ( SELECT * FROM ( SELECT 'idealo.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_idealo.* FROM beny_suggestions_idealo UNION SELECT 'google.de' as MARKETPLACE, SUBSTRING(ID, 2, 1) AS FIRMA, SUBSTRING(ID, 4, 7) AS ARTE, SUBSTRING(ID, 11, 5) AS APNR, TRIM(TRAILING '-' FROM (CONCAT(CONCAT(TRIM(LEADING 0 FROM SUBSTRING(ID, 4, 7)),'-'), TRIM(LEADING 0 FROM SUBSTRING(ID, 11, 5))))) AS ORDERNUMBER, beny_suggestions_google.* FROM beny_suggestions_google ) as t1 ) as t1 GROUP BY t1.MANUFACTURER, t1.EAN Mapping: MARKETPLACE: t1.MARKETPLACE FIRMA: t1.FIRMA ARTE: t1.ARTE APNR: t1.APNR ORDERNUMBER: t1.ORDERNUMBER ID: t1.ID PRODUCTNAME: t1.PRODUCTNAME CATEGORY: t1.CATEGORY MANUFACTURER: t1.MANUFACTURER MODEL: t1.MODEL EAN: t1.EAN MPN: t1.MPN STATUS: t1.STATUS RANKING: t1.RANKING SHIPPINGCOSTS: t1.SHIPPINGCOSTS SHOP: t1.SHOP SHOP_URL: t1.SHOP_URL NEWPRICE: t1.MINNEWPRICE OLDPRICE: t1.OLDPRICE PRICECHANGE: t1.PRICECHANGE LASTUPDATE: t1.LASTUPDATE BESTOFFERER: t1.BESTOFFERER BESTPRICE: t1.BESTPRICE TOTALPRICE: t1.TOTALPRICE NEWTOTALPRICE: t1.NEWTOTALPRICE AVAILABILITY: t1.AVAILABILITY DEEPLINK: t1.DEEPLINK LISTED: t1.LISTED CURRENTPRICE: t1.CURRENTPRICE AnbieterPreis: t1.AnbieterPreis
Definition aktualisieren