topic Add a header from a context or another file in Talend Studio

Add a header from a context or another file

lcupito — Fri, 15 Nov 2024 21:20:11 GMT

Hi everyone,

i had a problem adding a header in a dynamic file.

I previously processed a file and in the output of the tjavarow I have the out field with the OBJECT type. I tried to insert it in the tjavarow but it prints the header for each row. However, the created file has no header. How do I add the header that I saved as context or as a column of another file?

Re: Add a header from a context or another file

Anonymous — Sat, 14 Oct 2023 17:37:28 GMT

Hope this KB article is helpful for you, it shows how to update the column properties including the column name when using Dynamic schema.

https://community.talend.com/s/article/Updating-column-properties-when-using-Dynamic-schema

Regards

Shong

Re: Add a header from a context or another file

lcupito — Sat, 14 Oct 2023 18:10:49 GMT

It's not for me, but thank you anyway.

Re: Add a header from a context or another file

Anonymous — Mon, 16 Oct 2023 05:18:16 GMT

can you show us the java code on tJavaRow? If I understand your requirement well, you need to access the column properties, get the column name and replace it with new name from context variable.

Re: Add a header from a context or another file

lcupito — Mon, 16 Oct 2023 17:05:47 GMT

This is my tJavaRow code:

String[] headers = context.W_INTESTAZIONE.split("\\|");

String result = "";

for (String header: headers) {

Object columnValue = input_row.data.getColumnValue(header);

if (columnValue != null) {

result += columnValue.toString() + "|";

} else {

result += "null|";

}

if (result.endsWith("|")) {

result = result.substring(0, result.length() - 1);

}

output_row.out = result;

In context.W_INTESTAZIONE.split("\\|") i have the headers passed from father job (column1|column2|column3 etc etc) and in output (Object datatype) i have only the value without headers. i need as a first row the header and the value after the first row.

Re: Add a header from a context or another file

CMolloy1698391524 — Tue, 07 Nov 2023 07:01:20 GMT

Thank you for the article link, you made my day 😊