Icon

kn_​forum_​42385_​replace_​strings_​questionnaire

Change Strings to Integer Numbers for questionnaire

Change Strings to Integer Numbers for questionnaire

Change Strings to Integer Numbers for questionnaire https://forum.knime.com/t/column-expressions-ifthenelse-change-1-string-value-in-case-of-multiple-number-options/42385/2?u=mlauber71modification (https://forum.knime.com/u/sforesti)=> this can be modified if there are more complicated transformations for different groups of variables questionnaire.xlsx*_1_to_6replaceChars($$CURRENTCOLUMN$$,"123456" ,"012345" )replaceChars($$CURRENTCOLUMN$$,"123456" ,"012345" )replaceChars($$CURRENTCOLUMN$$,"123456" ,"012345" )Node 6new_answer*_1_to_6Node 9new_answerNode 12Node 13new_answerNode 15Node 16new_answer*_1_4Node 19*_1_5new_answerNode 22new_answerNode 24Node 25Node 26Node 27Node 28Node 29Node 30 Excel Reader String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) String ToNumber (PMML) Column Expressions Column Filter Column ListLoop Start Column Filter Column Rename Loop End (ColumnAppend) Column Filter Column ListLoop Start Loop End (ColumnAppend) Column Expressions Column Filter Column Rename Column Filter Column Filter Loop End (ColumnAppend) Column Expressions Column ListLoop Start Column Rename Joiner Joiner RowID RowID RowID Change Strings to Integer Numbers for questionnaire https://forum.knime.com/t/column-expressions-ifthenelse-change-1-string-value-in-case-of-multiple-number-options/42385/2?u=mlauber71modification (https://forum.knime.com/u/sforesti)=> this can be modified if there are more complicated transformations for different groups of variables questionnaire.xlsx*_1_to_6replaceChars($$CURRENTCOLUMN$$,"123456" ,"012345" )replaceChars($$CURRENTCOLUMN$$,"123456" ,"012345" )replaceChars($$CURRENTCOLUMN$$,"123456" ,"012345" )Node 6new_answer*_1_to_6Node 9new_answerNode 12Node 13new_answerNode 15Node 16new_answer*_1_4Node 19*_1_5new_answerNode 22new_answerNode 24Node 25Node 26Node 27Node 28Node 29Node 30Excel Reader String Manipulation(Multi Column) String Manipulation(Multi Column) String Manipulation(Multi Column) String ToNumber (PMML) Column Expressions Column Filter Column ListLoop Start Column Filter Column Rename Loop End (ColumnAppend) Column Filter Column ListLoop Start Loop End (ColumnAppend) Column Expressions Column Filter Column Rename Column Filter Column Filter Loop End (ColumnAppend) Column Expressions Column ListLoop Start Column Rename Joiner Joiner RowID RowID RowID

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2022-05-01
On NodePit since: 2022-05-01
Last update: 2024-04-26
Created with KNIME version: v4.5.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!