topic Re: How to map global variable into insert statement (Output component)? in Talend Studio

How to map global variable into insert statement (Output component)?

Romanesku — Mon, 02 Oct 2017 08:03:50 GMT

Hi,

simple task, how to map global variable into Output component? I have job, where I do synchronization and after success or failed execution, I want to insert into log table some values from global variables which I have setted in process. I tried to use tMap, but there is compilation error "var cannot be rrsolved to a variable". What is the pattern for this?

Thanks.

Re: How to map global variable into insert statement (Output component)?

TRF — Mon, 02 Oct 2017 08:26:53 GMT

Hi,

Global variables are available using "globalMap.get" method. Here is an example for a String variable:

(String)globalMap.get("yourVariable")

Re: How to map global variable into insert statement (Output component)?

Romanesku — Mon, 02 Oct 2017 08:33:48 GMT

Hi,

that is clear, but I do not know which component can I use for this declaration. Now I am tring use tFlexFlowInput, where I have two columns one for each variable. This tFlexFlowInput is joined with Output table.

Current problem is Type mismatch: cannot convert from STring to date

Re: How to map global variable into insert statement (Output component)?

Anonymous — Mon, 02 Oct 2017 09:34:23 GMT

Your problem is that your DB table is expecting a Date and you are supplying a String. You need to convert your String value to a Date. You can use this included routine/method to convert it in Talend.....

routines.TalendDate.parseDate(pattern, stringDate)

Re: How to map global variable into insert statement (Output component)?

nmodi — Mon, 02 Oct 2017 16:08:53 GMT

I am having the same issue, How did you generalize to get all global variable values outputted from every component.

even I want to capture all those global variable values in internal audit log table.

for example, tFTPPut knoww what file it uploaded onto FTP, I need to fetch that last once it uploaded successfully & add that into our internal audit log table.

Re: How to map global variable into insert statement (Output component)?

Romanesku — Mon, 02 Oct 2017 20:10:23 GMT

Hi nmodi,

now I am using fFixedFlowInput where for each variable is set one row Column with name and in Value with (String)globalMap.get("MyStringVariable"), (Integer)globalMap.get("MyNumberVariable") or (Date)globalMap.get("MydateVariable"). The rows were created in Edit schema. And this table is mapped with Output component with Insert action on data.

regards,

Roman