Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get the Highest Value from an Certain String

Talend Open Studio

Version:  6.3.1

 

Hello everybody

 

I there any possibilty to get only Records with an highest Value of an String.

 

For example.

 

Offers which  has the following  Records names:

1002-001, 1002-002,  1003,  1004-001,

 

And i only want the following Records:

1002-002, 1003, 1004

 

I have searched for some methods in java and I'm not sure if i could use these function for it 

https://www.tutorialspoint.com/java/number_max.htm .. if so how i have to integrate this  in talend ? 

 

best regards john 

 

 

Labels (3)
12 Replies
Anonymous
Not applicable
Author

Well the additional fields need to be mentioned in either the group by operations or in the aggregate operations for them to be passed to the output.

So depending on the data, you can figure out on which columns 'group by' can be done and on which columns you can perform aggregations.

Anonymous
Not applicable
Author

Hello @ArvinRapt

 

Thanks for help 

 

But atm. we have an bigger Problem in our Prod System which I've mentioned Here.

 

Moreover i will rethink over the job to solve this with some extra ID's which are created on Upload before.

 

May this is an better way of thinking.

 

But as i said, this is just in a test environment the other one not. 

 

best regards john  

 

Anonymous
Not applicable
Author

Methods, method parameters, interaction and overloading