Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
what exactly do you mean by maximum characters ? Can you provide some input and desired output example ?
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.
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