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

[Anonymous]

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

[manodwhb]

@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

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

This is not Working !!
@abhishek

[Anonymous]

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

Best Regards,
Abhishek

[manodwhb]

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

[Anonymous]

@abhishek

[manodwhb]

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

[Anonymous]

@manodwhb

Still getting an error 

in tLogRow there is only one field row1.File_Name