topic Re: How to write context variable dynamically to tFileInputDelimited in Talend Studio

How to write context variable dynamically to tFileInputDelimited

Anonymous — Sat, 16 Nov 2024 07:25:07 GMT

Hi,

Below is my job design,

tFileInputDelimited_1 -> tFlowtoIterate_1 -> tJavaFlex -> tFileInputDelimited_2 -> tJavaRow -> tFlowtoIterate_2 -> tHiveInput -> tFileOutputDelimited_1

I am setting a context variable as below in the tJavaRow.

System.out.println("Value Of Input: "+input_row.table_name);
globalMap.put("varTOP", input_row.table_name);
System.out.println("Value Of GlobalVar: "+globalMap.get("table_name"));

My problem is,

I need to send the context value of "table_name" dynamically to tFileOutputDelimited_1 and append along with each output record.

eg:-<table_name>-<result_set> ( i am using the delimiter as "-")

emp-1-firstname-lastname-3545-address-phone-email

dept-1-hghg-jkh-546-dpet-trtr

Please suggest how to send that contextVariable and append in the tFileOutputDelimited.

Re: How to write context variable dynamically to tFileInputDelimited

TRF — Tue, 23 Oct 2018 14:55:49 GMT

Why don't you add a pseudo-column to your query with the tablename?

select 'EMP', code, firstname, lastname from EMP;

Re: How to write context variable dynamically to tFileInputDelimited

Anonymous — Wed, 24 Oct 2018 09:03:04 GMT

just add one more column in tjavarow schema and set its value using globalMap.get("table_name") ,

pass this flow as it is to tFlowToIterate and sync this schema to tHive and tfileoutputDelimited

Re: How to write context variable dynamically to tFileInputDelimited

Anonymous — Thu, 25 Oct 2018 11:40:06 GMT

@TRF @CK395

Sorry for the delay in the response.

Thanks @TRF - This is working for me, Surprising that, i missed this simple tweak.

@CK395 - I will work on your reply as well, and i will let you know, if that is working

Re: How to write context variable dynamically to tFileInputDelimited

TRF — Thu, 25 Oct 2018 12:30:16 GMT

Great!
@marskid4u, thanks to mark your case as solved