Hello everybody, is there a smart way to aggregate the values of 2 columns according to their sequence? For example: Id Previous_page Page 1 / /Page_c 1 /Page_a /Page_e 1 /Page_c /Page_a 2 / /Page_b 2 /Page_b /Page_c 3 / /Page_b 3 /Page_a /Page_d 3 /Page_b /Page_a 3 /Page_d /Page_c so the new column should contain: ID Sequence 1 /;Page_c;Page_a;Page_e 2 /;Page_b;Page_c; 3 /;Page_b;Page_a;Page_d;page_c Best, Alfredo

Hi @badger101 Thanks for your help! I finally managed to find a solution that works for me as it fully supports reverse paths as well. I renamed the workflow according to the name of this thread. Ciao Alfredo Pathway_Analysis.knwf (70.4 KB)

Website visitor pathway analysis

KNIME Analytics Platform

alfroc August 8, 2022, 12:40pm 14

Hi @badger101,
such a solution would be great!
Actually it seems like I’m not the only one interested …
All the best
Alfredo