topic Re: Setting a context variable with a value contains one ROW of database using tJava in Talend Studio

Setting a context variable with a value contains one ROW of database using tJava

Anonymous — Mon, 28 May 2018 07:03:41 GMT

How to set Context Variable from tMap which fetches the Row.File_name from databse such that i can use that Context Variable in tFileInputExcel as a File Name

ScreenShot of Problem has been Shared BelowWant to set row1.file_Name in Context VariableOutPut contains File Name and Date want to set FileName as Context Variable such that i can use that fileName in any component

OutPut contains File Name and Date want to set FileName as Context Variable such that i can use that fileName in any component

Re: Setting a context variable with a value contains one ROW of database using tJava

manodwhb — Mon, 28 May 2018 07:22:31 GMT

@meetmahajan,after tlog use tContextLoad.

Check below links,how to use tContextLoad

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/xH2TyYr_AmQnKwOYlqVCvA

https://community.talend.com/t5/Design-and-Development/tContextLoad/m-p/121426#M76577

Re: Setting a context variable with a value contains one ROW of database using tJava

Anonymous — Mon, 28 May 2018 07:24:40 GMT

Hi,

After tMap use tJavaRow here, In tJavaRow use below code -
context.filename = <row>.filename
This code will set the value in context variable, then using OnSubJobOk, you can use this variable to read file.

Best Regards,
Abhishek

Re: Setting a context variable with a value contains one ROW of database using tJava

Anonymous — Mon, 28 May 2018 07:31:27 GMT

@manodwhb
How can i set row1.file_name in tContextLoad
there is no field in which i can set key and value

Re: Setting a context variable with a value contains one ROW of database using tJava

Anonymous — Mon, 28 May 2018 07:32:21 GMT

This is not Working !!
@abhishek

Re: Setting a context variable with a value contains one ROW of database using tJava

Anonymous — Mon, 28 May 2018 07:34:25 GMT

Could you please provide a screenshot how are you using it
OR
Where is it failing ?

Best Regards,
Abhishek

Re: Setting a context variable with a value contains one ROW of database using tJava

manodwhb — Mon, 28 May 2018 07:37:27 GMT

@meetmahajan,you should get only one field into tlog that filename

Re: Setting a context variable with a value contains one ROW of database using tJava

Anonymous — Mon, 28 May 2018 07:38:53 GMT

@abhishek

Re: Setting a context variable with a value contains one ROW of database using tJava

manodwhb — Mon, 28 May 2018 07:40:39 GMT

@meetmahajan Transfer field should be created in context tab with sting type.

Re: Setting a context variable with a value contains one ROW of database using tJava

Anonymous — Mon, 28 May 2018 07:42:23 GMT

@manodwhb

Still getting an error

in tLogRow there is only one field row1.File_Name

Re: Setting a context variable with a value contains one ROW of database using tJava

manodwhb — Mon, 28 May 2018 07:48:04 GMT

@meetmahajan,you can create belwo way also.

Re: Setting a context variable with a value contains one ROW of database using tJava

manodwhb — Mon, 28 May 2018 07:58:47 GMT

@meetmahajan,context load.Transfer field should be created in context tab with sting type.

Re: Setting a context variable with a value contains one ROW of database using tJava

Anonymous — Mon, 28 May 2018 08:26:32 GMT

Thank You so Much @manodwhb, for your Precious guidance, it worked properly.

Thank @abhishek for solution