Icon

kn_​forum_​42327_​first_​position_​not_​null

forum question (42327) - select the first column per row with not-null values - seleccionar a primeira coluna por linha com valores não-nulos

forum question (42327) - select the first column per row with not-null values - seleccionar a primeira coluna por linha com valores não-nulos

forum question (42327) - select the first column per row with not-null values - seleccionar a primeira coluna por linha com valores não-nulos /data/sample.xlsxClienteSTART loop=>decide which columns to useexclude IDs etcdecidir quais as colunas a utilizar; excluir IDs, etcdo it perCliente (ID)use the samecolumnscol_$1Clientemake sure thecolumn after transpose isalways the same"column"certifique-se de que ocoluna após a transposição ésempre o mesmo"coluna""column"MISSING $column$ => FALSETRUE => TRUEcreatea countercriarum contador$Counter$ = 0 => TRUETRUE => FALSEcolumn_with_first_non_zerofirst_non_zero_valueClientestore the IDrow_idstore the originalRowIDarmazenar o originalRowIDcolumn_with_first_non_zeroexcludeCounterEND Loopcollect resultsrecolha de resultadosbringback theresults/data/result.xlsx Excel Reader Table Row ToVariable Loop Start Column Filter Rule-basedRow Filter Transpose ReferenceColumn Filter Column Rename(Regex) Column Rename ConstantValue Column RowID Rule-basedRow Filter Counter Generation Rule-basedRow Filter RowID Column Rename ConstantValue Column ConstantValue Column RowID Column Filter Loop End Joiner Excel Writer forum question (42327) - select the first column per row with not-null values - seleccionar a primeira coluna por linha com valores não-nulos /data/sample.xlsxClienteSTART loop=>decide which columns to useexclude IDs etcdecidir quais as colunas a utilizar; excluir IDs, etcdo it perCliente (ID)use the samecolumnscol_$1Clientemake sure thecolumn after transpose isalways the same"column"certifique-se de que ocoluna após a transposição ésempre o mesmo"coluna""column"MISSING $column$ => FALSETRUE => TRUEcreatea countercriarum contador$Counter$ = 0 => TRUETRUE => FALSEcolumn_with_first_non_zerofirst_non_zero_valueClientestore the IDrow_idstore the originalRowIDarmazenar o originalRowIDcolumn_with_first_non_zeroexcludeCounterEND Loopcollect resultsrecolha de resultadosbringback theresults/data/result.xlsxExcel Reader Table Row ToVariable Loop Start Column Filter Rule-basedRow Filter Transpose ReferenceColumn Filter Column Rename(Regex) Column Rename ConstantValue Column RowID Rule-basedRow Filter Counter Generation Rule-basedRow Filter RowID Column Rename ConstantValue Column ConstantValue Column RowID Column Filter Loop End Joiner Excel Writer

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-27
Created with KNIME version: v4.5.2
Tags: firstnonnullloop

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

Try NodePit Runner!