Adding new column based on multiple other columns

Bas1111 · June 27, 2019, 7:21am

Hi All,

I hope you can help me. I have a data set with 36 columns, in the columns, the cells contain either a value or “Null”. I want to create a new column “datatype” that contains the column header of the column that contains a value.

In some cases there is a value in two or more columns. In that case more new columns need to be added “datatype 2”, “datatype 3”.

I would really appreciate your help, I can’t find the correct node or combination of nodes.

Regards.

armingrudd · June 27, 2019, 10:24am

Hi and welcome to the community @Bas1111,

Here you are the workflow you requested:

datatype.knwf (30.9 KB)

Feel free to ask any other questions.

ipazin · June 27, 2019, 10:54am

Hi there @Bas1111 ,

not sure I understand what are you trying to accomplish. Is @armingrudd solution what you were looking for?

Br,
Ivan

Bas1111 · June 27, 2019, 10:58am

Hi @armingrudd
Thank you, this does exactly what I needed.

kind regards!
Bas

system · July 4, 2019, 10:58am

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