Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@JM39 , in the Expression you nee add value for each filed like "Test_value" in the tMap.
@JM39 ,check the below screen shot.
That's worked - really useful and clear response - thank you!