Icon

Medical Procedure Prices

33_Medical Procedure Prices
local folderKaiserrelSheetsSutterrelSheetsrelSheetsHospital ChainHospital Chaincol Bto be filledeach Sheetgetprocedure dataget Hospitalget HospitaldeleteCategory rowsget Categoryfill CategoryAvg PriceAvg Priceper procedurePrice to be filledCategory fix0 Kaiser1 Sutterstd devPricestd devPriceString Manipulation(Variable) String to Path(Variable) Read ExcelSheet Names Row Filter Read ExcelSheet Names Row Filter Row Filter Concatenate Rule Engine Path to String Rule Engine Row Filter Table Row ToVariable Loop Start Excel Reader Loop End String Manipulation Excel Reader Table Rowto Variable Column Rename Row Filter Rule Engine Missing Value String To Number GroupBy Row Filter String Manipulation Variable toTable Column Row Splitter GroupBy GroupBy local folderKaiserrelSheetsSutterrelSheetsrelSheetsHospital ChainHospital Chaincol Bto be filledeach Sheetgetprocedure dataget Hospitalget HospitaldeleteCategory rowsget Categoryfill CategoryAvg PriceAvg Priceper procedurePrice to be filledCategory fix0 Kaiser1 Sutterstd devPricestd devPriceString Manipulation(Variable) String to Path(Variable) Read ExcelSheet Names Row Filter Read ExcelSheet Names Row Filter Row Filter Concatenate Rule Engine Path to String Rule Engine Row Filter Table Row ToVariable Loop Start Excel Reader Loop End String Manipulation Excel Reader Table Rowto Variable Column Rename Row Filter Rule Engine Missing Value String To Number GroupBy Row Filter String Manipulation Variable toTable Column Row Splitter GroupBy GroupBy

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: th
Created at: 2022-09-11
On NodePit since: 2022-09-12
Last update: 2024-11-21
Created with KNIME version: v4.5.1
Tags: justknimeit-33justknimeit

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

Try NodePit Runner!