I'm a newbie to Talend and Java. My problem is, how use context variables in a MSSQLInput component.
SELECT TOP (10)
,([Quantity]) as 'Menge'
,[ResourceGroupName] as 'ResourceGrp'
, [CustomerName] as 'Kunde'
,CONVERT(VARCHAR(10), [UsageStartUtc], 105) as 'Datum'
,'"+CSPBilling.DatumVon+"' as 'von'
,'"CSPBilling.DatumBis"' as 'bis'
In this example are 2 context variables CSPBilling.DatumVon and CSPBilling.DatumBis. The variables are string and hold dates in the yyyy-mm-dd format. My problem is, that the variables will be replaced in runtime. I added some screenshots to show the situation (definition of the variables and result of the query. Thank you for any help.
Solved! Go to Solution.