Maximum Characters in a Excel Column

[EThanumalayan1602246470]

Hi Everyone,

I am trying to Perform a ETL Job by converting Excel to another template of Excel. In this Excel, I am facing a challenge.

There is a Column "DescCode" in the Source file, which may contain any number of characters. Ex : "10001",125689",15236-SRO". Now I would like to find the maximum characters in the "DescCode" column and have to perform some operations.

I couldn't able to find out any functions / expressions in talend to find it. Can you help me to do.

-

Thanks

[pakapi_]

Hi,

what exactly do you mean by maximum characters ? Can you provide some input and desired output example ?

[EThanumalayan1602246470]

Hi @Kamil Kowalczyk​ , Kindly find the sample input columns as below.

Now I need the Maximum characters = "9" to be the Desired Output. Since "15236-SRO" has 9 Chars.

[pakapi_]

If I understand it correctly:

Link your input file with tJavaRow, and add length of every DescCode row:

output_row.DescCodeLength = input_row.DescCode.length();

Then use tAggregateRow, to return max value of your input