topic Re: Generate Header after creation of file in Talend Studio

Generate Header after creation of file

BA621858188 — Tue, 21 Feb 2023 12:52:17 GMT

Hi Team,

I wanted to generate a custom header after the creation of a file and not before file creation. How can I achieve this?

Thanks in advance.

Re: Generate Header after creation of file

Anonymous — Wed, 22 Feb 2023 08:05:05 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Generate Header after creation of file

Anonymous — Wed, 22 Feb 2023 08:08:40 GMT

After the creation of a file, read the file content as a string using tFileInputRaw, pass it to tJavaRow and store the content string as a global variable, eg:

globalMap.put("content",input_row.content.toString());

In the next subjob, generate a head string on tFixedFlowInput, pass it to tJavaRow and concatenate the header string with the file content string, eg:

output_row.columnName=input_row.columnName+"\r\n"+(String)globalMap.get("content");

Generate a new file using tFileOutputRaw, the job design looks like:

tFileInputRaw--main--tJavaRow

|onsubjobok

tFixedFlowInput--main--tJavaRow--tFileOutputRaw.

Regards

Shong

Re: Generate Header after creation of file

BA621858188 — Thu, 23 Feb 2023 13:33:54 GMT

Thanks @Shicong Hong It worked.