Moving data between columns

Hi,

in a csv-file the column delimiter has also been used as a value in column 9. This results in an additional column. Correcting this in python/pandas is quite simple. The following code shifts the data in these rows back to the right columns:

mask = df.iloc[:, -1].notna()

df.loc[mask, df.columns[8:]] = (df.loc[mask, df.columns[8:]].shift(-1, axis=1).values)

I could not think of a simple solution for this in KNIME. Isn’t there any or did I miss something?

Regards

Dirk