Icon

Eilers_​ETL_​v7_​pending

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

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

Eliers Casino Count - ask Eliers to send us this file monthly to replace Raw Data Detail crosstab files # of casinos Create backup to csv with timestamp at file name Additional excel file load Note: It seems like Eilers removed Theo Win vs House and Theo Win vs Zone 2023-10-30Change Net Win vs. House to Theo Win vs. HouseChange Net Win vs. Zone to Theo Win vs. Zone Create flow variablewith file name,including the execution dateReplace Missing ValueTotal_Avg_Coin_In_Index_vs_HouseTotal_Avg_Coin_In_Index_vs_ZoneTotal_Avg_Theo_Net_Win_Index_vs_ZoneCabinetOutputRemove TimeRename ColumnsSort ColumnsAdd ColumnOverwrite T_Eilers_RawDataCheck MonthEilersNot in Eilers New DataRemove ColumnsRename ColumnsCopy T_Eilers_RawDataMax BetCabinetAdd ColumnTotal_Avg_Coin_In_Index_vs_HouseRemove TimeMax BetReplace Missing ValueTotal_Avg_Theo_Net_Win_Index_vs_ZoneTotal_Avg_Coin_In_Index_vs_ZoneSort ColumnsCabinetAdd ColumnTotal_Avg_Coin_In_Index_vs_HouseRemove TimeMax BetReplace Missing ValueTotal_Avg_Theo_Net_Win_Index_vs_ZoneTotal_Avg_Coin_In_Index_vs_ZoneSort ColumnsCabinetAdd ColumnTotal_Avg_Coin_In_Index_vs_HouseRemove TimeMax BetReplace Missing ValueTotal_Avg_Theo_Net_Win_Index_vs_ZoneTotal_Avg_Coin_In_Index_vs_ZoneSort ColumnsExcluded Grand TotalExcluded Grand TotalExcluded Grand TotalExcluded Grand TotalDenom $Denom $Denom $Denom $Rename ColumnsRename ColumnsRename ColumnsT_Eilers_Casino_CountNot In Excel, need to addFound or Not FoundEilers_Casino_CountBackup Connect to ProdMgmt Connect to ProdMgmtExcel File from Eilers Connect to ProdMgmtCreate path flowvariabe using the createdfile nameEverivwThemeLookupTheme Not FoundThemeLookupNon Everi ThemeBackupExcluded Grand TotalReplace Missing ValueTotal_Avg_Theo_Net_Win_Index_vs_ZoneTotal_Avg_Coin_In_Index_vs_ZoneCabinetSort ColumnsAdd ColumnTotal_Avg_Coin_In_Index_vs_HouseRemove TimeMax BetDenom $Total_Avg_Theo_Net_Win_Index_vs_HouseRename ColumnsBackup FilterTotal_Avg_Theo_Net_Win_Index_vs_HouseTotal_Avg_Theo_Net_Win_Index_vs_HouseTotal_Avg_Theo_Net_Win_Index_vs_HouseTotal_Avg_Theo_Net_Win_Index_vs_HouseFill Missing ColumnsRecalculated Theo IndexesRecalculated Theo IndexesFill Missing ColumnsExcel Reader (XLS)(deprecated) String Manipulation(Variable) Missing Value Math Formula Math Formula Math Formula String Replacer CSV Writer(deprecated) Modify Time Column Rename(deprecated) Column Resorter String Replacer Concatenate DB Writer GroupBy Concatenate DB Query Reader Joiner (deprecated) String to Date&Time Row Filter String to Date&Time Column Filter Column Rename(deprecated) DB Writer Concatenate Metanode String Replacer String Replacer Math Formula Modify Time Metanode Excel Reader (XLS)(deprecated) Missing Value Math Formula Math Formula Column Resorter String Replacer String Replacer Math Formula Modify Time Metanode Excel Reader (XLS)(deprecated) Missing Value Math Formula Math Formula Column Resorter String Replacer String Replacer Math Formula Modify Time Metanode Excel Reader (XLS)(deprecated) Missing Value Math Formula Math Formula Column Resorter String to Date&Time Row Filter Row Filter String to Date&Time Row Filter String to Date&Time Row Filter String to Date&Time String Replacer String To Number String Replacer String To Number String Replacer String To Number String Replacer String To Number Column Rename(deprecated) Column Rename(deprecated) Column Rename(deprecated) DB Writer Column Filter Joiner (deprecated) Row Splitter DB Query Reader Modify Time CSV Writer(deprecated) Microsoft SQLServer Connector Microsoft SQLServer Connector Excel Reader Microsoft SQLServer Connector CSV Writer Create Date&TimeRange Date&Time to String Create File/FolderVariables Table RowTo Variable GroupBy Row Filter DB Query Reader Joiner Table Creator ReferenceRow Filter Strip UpperFilter Duplicate Strip UpperFilter Duplicate Strip UpperFilter Duplicate Excel Reader (XLS)(deprecated) Row Filter String to Date&Time Missing Value Math Formula Math Formula String Replacer Column Resorter String Replacer Math Formula Modify Time Metanode String Replacer String To Number Math Formula Column Rename(deprecated) Rule-basedRow Filter Table Creator Cross Joiner Column Filter Math Formula Math Formula Math Formula Math Formula Column Expressions Column Expressions Column Expressions Column Expressions Eliers Casino Count - ask Eliers to send us this file monthly to replace Raw Data Detail crosstab files # of casinos Create backup to csv with timestamp at file name Additional excel file load Note: It seems like Eilers removed Theo Win vs House and Theo Win vs Zone 2023-10-30Change Net Win vs. House to Theo Win vs. HouseChange Net Win vs. Zone to Theo Win vs. Zone Create flow variablewith file name,including the execution dateReplace Missing ValueTotal_Avg_Coin_In_Index_vs_HouseTotal_Avg_Coin_In_Index_vs_ZoneTotal_Avg_Theo_Net_Win_Index_vs_ZoneCabinetOutputRemove TimeRename ColumnsSort ColumnsAdd ColumnOverwrite T_Eilers_RawDataCheck MonthEilersNot in Eilers New DataRemove ColumnsRename ColumnsCopy T_Eilers_RawDataMax BetCabinetAdd ColumnTotal_Avg_Coin_In_Index_vs_HouseRemove TimeMax BetReplace Missing ValueTotal_Avg_Theo_Net_Win_Index_vs_ZoneTotal_Avg_Coin_In_Index_vs_ZoneSort ColumnsCabinetAdd ColumnTotal_Avg_Coin_In_Index_vs_HouseRemove TimeMax BetReplace Missing ValueTotal_Avg_Theo_Net_Win_Index_vs_ZoneTotal_Avg_Coin_In_Index_vs_ZoneSort ColumnsCabinetAdd ColumnTotal_Avg_Coin_In_Index_vs_HouseRemove TimeMax BetReplace Missing ValueTotal_Avg_Theo_Net_Win_Index_vs_ZoneTotal_Avg_Coin_In_Index_vs_ZoneSort ColumnsExcluded Grand TotalExcluded Grand TotalExcluded Grand TotalExcluded Grand TotalDenom $Denom $Denom $Denom $Rename ColumnsRename ColumnsRename ColumnsT_Eilers_Casino_CountNot In Excel, need to addFound or Not FoundEilers_Casino_CountBackup Connect to ProdMgmt Connect to ProdMgmtExcel File from Eilers Connect to ProdMgmtCreate path flowvariabe using the createdfile nameEverivwThemeLookupTheme Not FoundThemeLookupNon Everi ThemeBackupExcluded Grand TotalReplace Missing ValueTotal_Avg_Theo_Net_Win_Index_vs_ZoneTotal_Avg_Coin_In_Index_vs_ZoneCabinetSort ColumnsAdd ColumnTotal_Avg_Coin_In_Index_vs_HouseRemove TimeMax BetDenom $Total_Avg_Theo_Net_Win_Index_vs_HouseRename ColumnsBackup FilterTotal_Avg_Theo_Net_Win_Index_vs_HouseTotal_Avg_Theo_Net_Win_Index_vs_HouseTotal_Avg_Theo_Net_Win_Index_vs_HouseTotal_Avg_Theo_Net_Win_Index_vs_HouseFill Missing ColumnsRecalculated Theo IndexesRecalculated Theo IndexesFill Missing ColumnsExcel Reader (XLS)(deprecated) String Manipulation(Variable) Missing Value Math Formula Math Formula Math Formula String Replacer CSV Writer(deprecated) Modify Time Column Rename(deprecated) Column Resorter String Replacer Concatenate DB Writer GroupBy Concatenate DB Query Reader Joiner (deprecated) String to Date&Time Row Filter String to Date&Time Column Filter Column Rename(deprecated) DB Writer Concatenate Metanode String Replacer String Replacer Math Formula Modify Time Metanode Excel Reader (XLS)(deprecated) Missing Value Math Formula Math Formula Column Resorter String Replacer String Replacer Math Formula Modify Time Metanode Excel Reader (XLS)(deprecated) Missing Value Math Formula Math Formula Column Resorter String Replacer String Replacer Math Formula Modify Time Metanode Excel Reader (XLS)(deprecated) Missing Value Math Formula Math Formula Column Resorter String to Date&Time Row Filter Row Filter String to Date&Time Row Filter String to Date&Time Row Filter String to Date&Time String Replacer String To Number String Replacer String To Number String Replacer String To Number String Replacer String To Number Column Rename(deprecated) Column Rename(deprecated) Column Rename(deprecated) DB Writer Column Filter Joiner (deprecated) Row Splitter DB Query Reader Modify Time CSV Writer(deprecated) Microsoft SQLServer Connector Microsoft SQLServer Connector Excel Reader Microsoft SQLServer Connector CSV Writer Create Date&TimeRange Date&Time to String Create File/FolderVariables Table RowTo Variable GroupBy Row Filter DB Query Reader Joiner Table Creator ReferenceRow Filter Strip UpperFilter Duplicate Strip UpperFilter Duplicate Strip UpperFilter Duplicate Excel Reader (XLS)(deprecated) Row Filter String to Date&Time Missing Value Math Formula Math Formula String Replacer Column Resorter String Replacer Math Formula Modify Time Metanode String Replacer String To Number Math Formula Column Rename(deprecated) Rule-basedRow Filter Table Creator Cross Joiner Column Filter Math Formula Math Formula Math Formula Math Formula Column Expressions Column Expressions Column Expressions Column Expressions

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: tim.mak
Created at: 2020-07-14
On NodePit since: 2025-10-22
Last update: 2025-10-22
Created with KNIME version: v5.1.0

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

Try NodePit Runner!