Translations:TAS:Pokročilé/Pluginy/Input, Output/Import/ScenarioImporter/SqlTransformCommandText/13/cs

<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: