How take multiple columns

[shubhamss]

First Name	Last Name	Middle Name
Max	Williams	J
Tom	Ford
Claire	Jenson
Bailley	Salon	Carson
Ben	Hamford	T
Beck	Jecko
Tommy	Gun	G

How do you add First, Middle and Last names, all in one Set.

[HansS]

Hi @shubhamss

Use the column appender node.
Gr. Hans

[Yush]

Try the ‘String Manipulation’ node. Then use the expression: string($First Name&+" “+$Middle Name$+” “+$Last Name”).

[ipazin]

Hi there,

@HansS you had Column Combiner node in mind? Not sure Column Appender node can do that

String Manipulation node can be nice in this case as it offers customizing with commas and/or dots on preferred positions.

Br,
Ivan

[Aswin]

Or you could Unpivot, and then Pivot using the List or Concatenation aggregation methods.

Sorry, I’ll see myself out

[HansS]

@ipazin you are right I had the Column Combiner node in mind. @shubhamss Excuses for the confusion

[shubhamss]

This is the data structure (I have): List (Collection of: Set (Collection of: String))

Where the List contains a set of First, Last and Middle Name. I intend to see if any of the names shows up in a comment (This comment has been broken down by spaces and may contain first, last and middle names).

[HansS]

Hi @shubhamss
a KNIME workflow with an some (example) data will be helpful to find a solution.
gr. Hans

[shubhamss]

I have sensitive data which I won’t be able to post on a public forum. Thanks for all your assistance. I felt like the matching could have using similarity search or string matcher. But the results are not accurate. So at the moment I am not sure of the specific nature of the string which leading to them default, when I crack that. I will post a example workflow.

Thanks