topic Re: Trouble with tJavaRow adding a column to the Dynamic in Talend Studio

Trouble with tJavaRow adding a column to the Dynamic

mdeeter — Wed, 28 Nov 2018 22:37:34 GMT

Hi all, I have a Talend enterprise job that is fairly resusable. One of the main functions of this job is to map column dynamically to a common output layout for PII data to be used in later steps.

I am struggling with the syntax to append a net new column to the dynamic column that is coming into the tJavarow.

I have the mapping of varied input data figured out but I can't seem to initialize the column so I can map data to it. Note, this works if I add the column in a prior step and just leaving the source blank (i.e. in tMap) and then use a tWriteDynamic prior to the tJavarow but I am hoping to keep this complexity all in the tJavarow component. Is there something wrong with this syntax? I am not getting the column back in the output_row in the next component.

Any ideas:

Dynamic CDI_Schema = input_row.CdiData;

for (int i = 0; i < CDI_Schema_1.getColumnCount(); i++)
{
DynamicMetadata columnMetadata = CDI_Schema.getColumnMetadata(i);
{CDI_Schema.addColumn("input_first_name" ,"String", true);}

if (columnMetadata.getName().equals("input_first_name" )){CDI_Schema.setColumnValue(i,CDI_Schema.getColumnValue((String)globalMap.get("input_first_name_column")));}

}

output_row.CdiData = CDI_Schema;

Re: Trouble with tJavaRow adding a column to the Dynamic

mdeeter — Thu, 29 Nov 2018 22:03:20 GMT

Anyone have experience with addColumn and a Dynamic column?

Re: Trouble with tJavaRow adding a column to the Dynamic

mdeeter — Tue, 04 Dec 2018 16:31:38 GMT

Hi, anyone have any suggestions on this?

Re: Trouble with tJavaRow adding a column to the Dynamic

User5923427525177642 — Mon, 15 May 2023 09:24:31 GMT

Hi mdeeter,

CDI_Schema.addColumn("input_first_name" ,"String", true) is not a void type but a dynamic type.

This one returns you CDI_Schema's value with added column.

So you have to write it like this : CDI_Schema = CDI_Schema.addColumn("input_first_name" ,"String", true);