Hi, I would like to add to my csv file on the top some extra row to look like below, I am not sure how to do it using talend. I have use a three different files from where I am doing mapping and look up but on the end when I insert to my csv file and just getting normal column population not sure how to make these empty rows before I get title for my second part. Any help is welcome. Thanks Zeljka colum1 colum2 column3 text, text , text , title1 title2, title3 tesxt text, text, text, text text text text text
Thanks Walkerca The code with add Variable working very good the only outstanding issue is that I still can't desplay title of my main file. If I run main file with out tForeach part my Title is there but when I make link between these two Please see these two images one is with title and one is with out when I link it with tForeach
Hi, I am able to sort date in my Rows where I am having DATE but I as I new in Talend not sure how I can create this line "#HEADER: " + context.DATA_DIR , I am not sure how to create context for exisitng tForeach job Thanks Zeljka
hi, I have try any solution to bring my title of my main file. I do not have problem to do my data as look like below text text text however when I become to bring titile of my part look like below I am just losing my title even if I tick Include header and append. this is quite important for me and so far I couldn't find any solution. Is anyone who can help. Thanks Z title title title title text text text text text text text text
Hi Zeljka
I am back to you, I understand your request now, you need redesign the job like this:
the first part(output the result to a file as you done, let's say it is test.csv)
|
the second part---tFileOutputDelimited(output the result to a temporary file, eg: temp.txt, note that check the box 'include header')
|
tFileInputFullRow(Read the temporary file temp.txt line by line)--main->tFileOutputDelimited(output the result to test.csv, note that check the box 'append')
Best regards
Shong
