Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
JM39
Creator
Creator

Setting a constant value in output file

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!

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@JM39 ,check the below screen 0683p000009MA5c.pngshot.

 

View solution in original post

3 Replies
manodwhb
Champion II
Champion II

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

manodwhb
Champion II
Champion II

@JM39 ,check the below screen 0683p000009MA5c.pngshot.

 

JM39
Creator
Creator
Author

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