Translations:TAS:Pokročilé/Pluginy/Input, Output/Import/ScenarioImporter/SqlTransformCommandText/13/pl
Verze z 26. 8. 2022, 08:39, kterou vytvořil Jana.safferova (diskuse | příspěvky) (založena nová stránka s textem „<SqlTransformCommandText> <![CDATA[ SELECT [col0_Zakazka] AS id ,[col1_NazevZakaznika] AS name ,CONCAT([col2_Ulice],', ',[col3_PSC],' ',[col4_Mesto]) as address ,0 AS x ,0 AS y ,[col6_Telefon] AS mobile ,CASE WHEN [col7_HmotnostKG] IS NULL THEN 0 ELSE [col7_HmotnostKG] END AS demand1 ,5 as duration ,'0600' as start1 ,'1800' as end1 ,2 as precedence ,'delivery' as stoptype ,[col5_Zeme] ,[col8_Dobirka] ,'' specialcodes…“)
<SqlTransformCommandText> <![CDATA[
SELECT [col0_Zakazka] AS id ,[col1_NazevZakaznika] AS name ,CONCAT([col2_Ulice],', ',[col3_PSC],' ',[col4_Mesto]) as address ,0 AS x ,0 AS y ,[col6_Telefon] AS mobile ,CASE WHEN [col7_HmotnostKG] IS NULL THEN 0 ELSE [col7_HmotnostKG] END AS demand1 ,5 as duration ,'0600' as start1 ,'1800' as end1 ,2 as precedence ,'delivery' as stoptype ,[col5_Zeme] ,[col8_Dobirka] , specialcodes INTO [afterTashaIOSqlEditTable] --tabulka s výstupními daty FROM [beforeTashaIOSqlEditTable] --tabulka se vstupními daty
]]> </SqlTransformCommandText> Ve scenarioimporteru pak je pak možné pracovat standardním způsobem: