Icon

20220215 Pikairos Count Atoms Ocurrence in Formula - modified by Thyme

20220215 Pikairos Count Atoms Ocurrence in Formula

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

insert "-"before capitalletter(elements start withcapital letters)split intoelement groups"-" as separatorungroup intomultiple rows(1 row for everyelement-count group)split elementsand countsinto separatecolumnsaggregate into1 column per elementmolecule formula as groupelement name as pivotelement count as sumremove"." and "-"Molecule ExamplesFinalAtom Countsampleinputappend "1"to elementswithout countinsert "-"between lettersand digitsrenametargetcolumn(same asabove)excludenon-moleculeincludemoleculeand element countsort byname ASCsort byname ASCcleanRowIDcleanRowIDassimilatestructurezerofillcomparetableremoveduplicateformulasString Manipulation Cell Splitter Ungroup Cell Splitter Pivoting Missing Value String Manipulation Table Creator InteractiveTable (local) Excel Reader String Manipulation String Manipulation Column Rename nicely wrapped Column Filter Column Filter Sorter Sorter RowID RowID Table Validator(Reference) Missing Value Table DifferenceFinder DuplicateRow Filter insert "-"before capitalletter(elements start withcapital letters)split intoelement groups"-" as separatorungroup intomultiple rows(1 row for everyelement-count group)split elementsand countsinto separatecolumnsaggregate into1 column per elementmolecule formula as groupelement name as pivotelement count as sumremove"." and "-"Molecule ExamplesFinalAtom Countsampleinputappend "1"to elementswithout countinsert "-"between lettersand digitsrenametargetcolumn(same asabove)excludenon-moleculeincludemoleculeand element countsort byname ASCsort byname ASCcleanRowIDcleanRowIDassimilatestructurezerofillcomparetableremoveduplicateformulasString Manipulation Cell Splitter Ungroup Cell Splitter Pivoting Missing Value String Manipulation Table Creator InteractiveTable (local) Excel Reader String Manipulation String Manipulation Column Rename nicely wrapped Column Filter Column Filter Sorter Sorter RowID RowID Table Validator(Reference) Missing Value Table DifferenceFinder DuplicateRow Filter

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-15
On NodePit since: 2022-02-16
Last update: 2024-04-28
Created with KNIME version: v4.5.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!