Icon

01_​SDS phrases extraction

SDS Risk Phrase Extraction
Execute the first wrapped metanode and change the Excel and ZIP file if you want to try with your data. Otherwise, execute the whole workflow.In the last wrapped metanode, download the resulting excel files. Read SDS in PDF format Text Mining Preprocessing PhrasesExtraction Post Processing Deployment ReadonlyPDFRisk Phrasessingle row matrixExtractsentencefrom documentUnpivotingall _Arr[*] columnsFilter outmissing value rowsSplit pathend inject the last part as variableCollect rowsas matrixPrint standardmessage when for any reason the upper partstops its executionConvertColumnValues Typeas StringExtract Risk PhrasesTOP: integer columnsBOTTOM: String columnsOrder columnsAppend Descriptionfor each Risk PhraseTransformcontent indocumentSplitsentence by line separator Tika Parser Try (Data Ports) Catch Errors(Data Ports) Sentence Extractor Unpivoting Row Filter gather filename Loop End If somethinggoes wrong... cast ColumnValuesas String Phrases Chunk Loop Start Input Column Splitter Column Resorter View Phrasesand Download Risk Description Strings To Document Cell Splitter Execute the first wrapped metanode and change the Excel and ZIP file if you want to try with your data. Otherwise, execute the whole workflow.In the last wrapped metanode, download the resulting excel files. Read SDS in PDF format Text Mining Preprocessing PhrasesExtraction Post Processing Deployment ReadonlyPDFRisk Phrasessingle row matrixExtractsentencefrom documentUnpivotingall _Arr[*] columnsFilter outmissing value rowsSplit pathend inject the last part as variableCollect rowsas matrixPrint standardmessage when for any reason the upper partstops its executionConvertColumnValues Typeas StringExtract Risk PhrasesTOP: integer columnsBOTTOM: String columnsOrder columnsAppend Descriptionfor each Risk PhraseTransformcontent indocumentSplitsentence by line separatorTika Parser Try (Data Ports) Catch Errors(Data Ports) Sentence Extractor Unpivoting Row Filter gather filename Loop End If somethinggoes wrong... cast ColumnValuesas String Phrases Chunk Loop Start Input Column Splitter Column Resorter View Phrasesand Download Risk Description Strings To Document Cell Splitter

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: User
Created at: 2018-08-06
On NodePit since: 2022-05-22
Last update: 2024-11-21
Created with KNIME version: v4.1.1
Tags: Safety Data SheetText MiningDangerous Chemicals

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

Try NodePit Runner!