STRING MANIPULATION

KNIME Analytics Platform
1

Good afternoon everyone, how are you?

I have a column that has ORIGIN and destination, being represented by the numbers 1 and two and in the next column I have the station. I would just like to transcribe what’s in row by column. I’m leaving the print as is the table together with the file and the print of how I would like it to appear.

image
image1831×399 51.8 KB

image
image1943×307 70.6 KB

KNIME_project.knwf (4.8 KB)

2

Hi,
You can do it with Pivot and Joiner as shown in the attached workflow.
KNIME_project.knwf (9.2 KB)

Kind regards,
Alexander

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.