topic Re: Maximum Characters in a Excel Column in Talend Studio

Maximum Characters in a Excel Column

EThanumalayan1602246470 — Fri, 09 Oct 2020 12:33:19 GMT

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

Re: Maximum Characters in a Excel Column

pakapi_ — Sun, 11 Oct 2020 12:28:21 GMT

Hi,

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

Re: Maximum Characters in a Excel Column

EThanumalayan1602246470 — Tue, 13 Oct 2020 12:14:56 GMT

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.

Re: Maximum Characters in a Excel Column

pakapi_ — Tue, 13 Oct 2020 18:56:02 GMT

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