Trying to figure out how to get an Excel sheet to recognize what links belong to a segment

PM No Build 2031 Redacted.xlsx (234.9 KB)

PM_No Build_2031_Link Segment Results.att.xlsx (187.9 KB)

Good Time Zone,

I have a question - the “Redacted” file has segment numbers that consist of individual links. How do I use the LINKEVALSEGMENT\LINK column in the other file to assign a segment to each link (just FYI I’ve already combined the individual lanes on each link into a single row in my workflow I’m just wondering if there’s a function I can use to give eacn link a segment number.

1 Like

@aselver you can give this a try. Split the Column with the links into individual lines and then join the segment via the links / numbers

Assign Segment to Links - KNIME Forum (91920).knwf (747.4 KB)

2 Likes