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
hi,
Thanks for your advice ..
I have done exactly how you did post on youtube but my second title not showing up.. can't figure out why as I am not doing anything different.
Z
hi, I have done everything as you suggested on your video but from my images you can see that I have still not having title in second part of the text even if I folow your instruction. any an indea what can cause that..
I am not sure if I am clear, the first part is coming very good, I am having all my data from the tForeach part, however my second file having title before every single column test, test, test, test . . . Title title title title text text text text should loook like this but I am having as I sowed on my image, the second part is only text but not title at all Thanks Zeljka
Also is any chance that I can pass any variable , I wanted in the first set of the data to put some date to be change in loop like current date where is Date stated, or no of Version or no of the Row. is this posible as all these row is under one column. Zeljka # BEGIN HEADER VERSION 1.1 # SENDERID: # CLIENTID: # DATE: # FILETYPE: # VERSION: # ROWS: # SEPARATOR: # END HEADER
Use the Java concatenation operator to join a variable to the header in the tForeach values. Some examples "#HEADER: " + context.DATA_DIR "#DATE: " + TalendDate.getCurrentDate()
