Icon

20220212 Pikairos consecutive count of last Yes sequence

20220210 Pikairos consecutive count

There has been no description set for this workflow's metadata.

Your Datawith fakeYesConvert Yes to 1and No to 0Your Datawith fakeNoSeparate IntegerNewlyCreated ColumnsSum the # of Times"Yes" (1)Appears alongColumnsConvert Occurencyinto your Required SentencesAppendthe Resulting"Pivot " calledColumnAppendthe Resulting"Pivot " calledColumnYour Datawith fakeYesSeparate IntegerNewlyCreated ColumnsYour Datawith fakeNoConvert Yes to 1and No to 0Convert Occurencyinto your Required SentencesConcatenate the"Yes" (1)&"No" (0)which appearalong ColumnsCalculate lengthof last appearingsequence of 1Table Creator String Manipulation(Multi Column) Missing Value Column Splitter Column Aggregator String Manipulation Column Appender Column Appender Table Creator Column Splitter Missing Value String Manipulation(Multi Column) String Manipulation Column Aggregator String Manipulation Your Datawith fakeYesConvert Yes to 1and No to 0Your Datawith fakeNoSeparate IntegerNewlyCreated ColumnsSum the # of Times"Yes" (1)Appears alongColumnsConvert Occurencyinto your Required SentencesAppendthe Resulting"Pivot " calledColumnAppendthe Resulting"Pivot " calledColumnYour Datawith fakeYesSeparate IntegerNewlyCreated ColumnsYour Datawith fakeNoConvert Yes to 1and No to 0Convert Occurencyinto your Required SentencesConcatenate the"Yes" (1)&"No" (0)which appearalong Columns Calculate lengthof last appearingsequence of 1Table Creator String Manipulation(Multi Column) Missing Value Column Splitter Column Aggregator String Manipulation Column Appender Column Appender Table Creator Column Splitter Missing Value String Manipulation(Multi Column) String Manipulation Column Aggregator String Manipulation

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: Molina
Created at: 2022-02-10
On NodePit since: 2022-02-13
Last update: 2024-05-02
Created with KNIME version: v4.4.1

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

Try NodePit Runner!