Dividir el valor de la celda en columnas

[elaadani]

Hi everyone ! I have a cell with 5 different values:

1: country
2: city
3: street
4: name
5: lastname

I would like to split them in different columns

1:country 2:city 3:street 4:name 5:lastname

But, in the next cell, the order of the values change like this

1: lastname
2: city
3: name
4: street
5: Country

How can I divide the values into different columns, but keep the number in the cell value? Like this:

country city street name lastname
1 2 3 4 5
5 2 4 3 1

Thanks u !

[izaychik63]

You can use

Column Resorter — NodePit

to restore necessary columns order.

[aworker]

Hola @elaadani,

Bienvenido al forum de KNIME!

I guess your initial data looks like this (from what you explained in your message) :

If so, please find here a possible solution to your question :

20200512 Pikairos Dividir el valor de la celda en columnas.knwf (40.0 KB)

Hope it helps to answer your question

Un saludo,

Ael

[elaadani]

Muchas muchas gracias ! @aworker

[aworker]

Con mucho gusto. Gracias por validar la solución y por el like ! Mucha suerte con respecto a su proyecto y a una proxima ocasión.

Saludos,

Ael