Icon

Just KNIME It _​ Challenge 033

Just KNIME It _ Challenge 033
Just KNIME It! - Challenge 33: Medical Procedure Prices unzipexcel sources compressed filefile PathsPath format typeinclude selected hospital branchesfile tabscontentread files collect normalicedsheets dataexclude 'Top 50 List' andAB 1045 FORMread tab sheetsread cells dataupper: headerlower: datanormalized sheet datareset RowIDcollect normalicedworkbooks dataAverage ChargeStatisticsAverage Chargeto numbersearch 1strow w. dataCapture from header section:1.- Hospital Branch (input)2.- Hospital Name3.- OSHPD_ID4.- Effective Date of ChargesSet Procedure TypecolumnSelect Top 5 based on Std. Dev.Assignunique 'CPT Code'unique 'Procedure' Unzip Files(legacy) URL to File Path String to Path Rule-basedRow Filter Read ExcelSheet Names Table Row ToVariable Loop Start Loop End(deprecated) Rule-basedRow Filter Table Row ToVariable Loop Start Excel Reader Rule-basedRow Splitter Cross Joiner RowID Loop End(deprecated) GroupBy String To Number 1st_data's_row Extract Header Info Procedure Type Top k Selector Data QC Results View Just KNIME It! - Challenge 33: Medical Procedure Prices unzipexcel sources compressed filefile PathsPath format typeinclude selected hospital branchesfile tabscontentread files collect normalicedsheets dataexclude 'Top 50 List' andAB 1045 FORMread tab sheetsread cells dataupper: headerlower: datanormalized sheet datareset RowIDcollect normalicedworkbooks dataAverage ChargeStatisticsAverage Chargeto numbersearch 1strow w. dataCapture from header section:1.- Hospital Branch (input)2.- Hospital Name3.- OSHPD_ID4.- Effective Date of ChargesSet Procedure TypecolumnSelect Top 5 based on Std. Dev.Assignunique 'CPT Code'unique 'Procedure' Unzip Files(legacy) URL to File Path String to Path Rule-basedRow Filter Read ExcelSheet Names Table Row ToVariable Loop Start Loop End(deprecated) Rule-basedRow Filter Table Row ToVariable Loop Start Excel Reader Rule-basedRow Splitter Cross Joiner RowID Loop End(deprecated) GroupBy String To Number 1st_data's_row Extract Header Info Procedure Type Top k Selector Data QC Results View

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: RE90273
Created at: 2022-09-14
On NodePit since: 2022-09-24
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: justknimeit-33

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

Try NodePit Runner!