Hi,
I am new Knime.
I have unique requirement to prepare data (messy database table) to identify unique workflow routes our applications have taken before it is finalized for optimization.
for data looks like
|Application#|Status|Date|
|App1|00|01/01/2024|
|App1|10|01/02/2024|
|App1|10|01/03/2024|
|App1|20|01/04/2024|
|App1|10|01/05/2024|
|App1|30|01/06/2024|
|App1|100|01/07/2024|
|App2|00|01/01/2024|
|App1|10|01/02/2024|
|App1|20|01/04/2024|
|App1|20|01/05/2024|
|App1|30|01/06/2024|
|App1|100|01/07/2024|
If the status remains same between 2 consecutive statuses, I need to count them as one record with max date between them.
I need the output to look like
|APP1|00-10-20-10-30-100|
|App2|00-10-20-30-100|
Any help appreciated.