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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!