Setting a constant value in output file

JM39 — Wed, 11 Mar 2020 10:49:53 GMT

Hello. I'm very new to Talend - I only just started using it yesterday and I haven't had any training. Just trying to go through the tutorial docs online so please bear with me.

I've created a tFileInputExcel file & I wanted to convert that to a tFileOutputDelimited (.dat) file.

I've also created a tMap to map the columns which are more or less one to one. However, in the output file I wanted to create two additional columns & assign a constant value in each of these columns. I thought I could do this by adding the column headers in the Map section & then putting the value in the Default column. It works in so far as it creates the columns in my output file, but the values are null. Any idea how I can achieve this? I've searched through the community posts and can't find anything specific to my issue. My tMap details are attached. TIA!

Re: Setting a constant value in output file

manodwhb — Wed, 11 Mar 2020 11:28:04 GMT

@JM39 , in the Expression you nee add value for each filed like "Test_value" in the tMap.

Re: Setting a constant value in output file

manodwhb — Wed, 11 Mar 2020 11:33:06 GMT

@JM39 ,check the below screen shot.

Re: Setting a constant value in output file

JM39 — Wed, 11 Mar 2020 14:12:33 GMT

That's worked - really useful and clear response - thank you!

topic Re: Setting a constant value in output file in Talend Studio

Setting a constant value in output file

Re: Setting a constant value in output file

Re: Setting a constant value in output file

Re: Setting a constant value in output file