Dear @ipazin 1st thanks in advance for your help
Hi there,
if you what to do it in a more KNIME way you can use Group Loop Start node together with Counter Generation node. Here is workflow print screen:
[SeqNumb]
And here is workflow attached to check it out:
2019_06_18_Generate_Seqence_Within_Group.knwf (13.7 KB)
Br,
Ivan
i ve tried it but it is not producing the results i need. here is the data below
CustomerID
Service
Channel
Satisfaction
Timestamp
1
Service A
Website
Not Satisfied
2024-08-01T10:00
4
Service D
Website
Not Satisfied
2024-08-02T11:02
1
Service A
Call Center
Satisfied
2024-08-01T10:15
2
Service B
Mobile App
Not Satisfied
2024-08-01T11:00
2
Service B
Website
Satisfied
2024-08-01T11:10
3
Service A
Email
Not Satisfied
2024-08-01T09:05
1
Service A
Email
Not Satisfied
2024-08-01T10:05
3
Service A
Call Center
Satisfied
2024-08-01T09:15
1
Service B
Website
Not Satisfied
2024-08-01T11:00
1
Service B
Email
Not Satisfied
2024-08-01T11:05
1
Service B
Call Center
Satisfied
2024-08-01T11:15
1
Service D
Website
Not Satisfied
2024-08-02T11:00
2
Service D
Website
Not Satisfied
2024-08-02T11:01
3
Service A
Website
Not Satisfied
2024-08-01T09:00
5
Service D
Website
Not Satisfied
2024-08-02T11:03
5
Service A
Website
Not Satisfied
2024-08-03T10:00
5
Service A
Email
Not Satisfied
2024-08-03T10:05
i need the sequence to be generated for each service and to restart even when a new customer is added to the same journey
can you plz help
2 Likes
ipazin
August 6, 2024, 9:33am
2
Hello @mh_elhassan ,
you are welcome. That seems to be a pretty popular thread with 10k views
Sure I can help. Can you share output you want for above data sample?
Br,
thanks a lot
below is the desired output
CustomerID
Service
Channel
Satisfaction
Timestamp
sequence
1
Service A
Website
Not Satisfied
2024-08-01T10:00
1
1
Service A
Email
Not Satisfied
2024-08-01T10:05
2
1
Service A
Call Center
Satisfied
2024-08-01T10:15
3
1
Service B
Website
Not Satisfied
2024-08-01T11:00
1
1
Service B
Email
Not Satisfied
2024-08-01T11:05
2
1
Service B
Call Center
Satisfied
2024-08-01T11:15
3
1
Service D
Website
Not Satisfied
2024-08-02T11:00
1
2
Service B
Mobile App
Not Satisfied
2024-08-01T11:00
1
2
Service B
Website
Satisfied
2024-08-01T11:10
2
2
Service D
Website
Not Satisfied
2024-08-02T11:01
1
3
Service A
Website
Not Satisfied
2024-08-01T09:00
1
3
Service A
Email
Not Satisfied
2024-08-01T09:05
2
3
Service A
Call Center
Satisfied
2024-08-01T09:15
3
4
Service D
Website
Not Satisfied
2024-08-02T11:02
1
5
Service A
Website
Not Satisfied
2024-08-03T10:00
1
5
Service A
Email
Not Satisfied
2024-08-03T10:05
2
5
Service D
Website
Not Satisfied
2024-08-02T11:03
1
ipazin
August 6, 2024, 11:20am
4
Hello @mh_elhassan ,
you can simply use Rank node where Grouping Attributes are CustomerID and Service while Ranking Attribute is Timestamp column. Follow it up with Sorter to get desired row order.
Br,
1 Like
Hi @mh_elhassan ,
Thanks for sharing the initial data, final data and the baseline workflow.
“Channel” column sequencing needs to be defined as using the alphabetical order would result in wrong result. I have defined it in a separate table.
Please accept the solution if correct.
The solution is below:
below is the output of the workflow that matches with desired result -
Regards,
Ajit
1 Like
@ajit555 thanks i ll try it out
