Dividir el valor de la celda en columnas

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 !

You can use


to restore necessary columns order.

Hola @elaadani,

Bienvenido al forum de KNIME!

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

20200512 Pikairos Dividir el valor de la celda en columnas data snapshot

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)

20200512 Pikairos Dividir el valor de la celda en columnas resultado

Hope it helps to answer your question :wink:

Un saludo,

Ael

6 Likes

Muchas muchas gracias ! @aworker

2 Likes

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

Saludos,

Ael

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