Icon

REF Challenge 33

Download data from link in the challenge.Store in the data folder in the workflow andthen run the Decompress Files node, You'llneed to reset the input file path. Loop Over FilesRead SheetsCostRemove Rowsw/ No ChargesRemove CaptionRowsCalculate Mean& Std. DeviationSutterLoop OverFilesRead FilesExclude TempFilesRemove Rowsw/ No ChargesRemove CaptionRowsCostCalculate Mean& Std. DeviationAdd CorrectColumn HeadersAdd CorrectColumn HeadersJoin Kaiser& Sutter Databy Procedure(Default - matchingrows)SutterMean / Std DevFinal TableNode 38Node 39KaiserMean / Std DevStrings =blanksNumbers = 0(Used when doingright or left joins)Node 43 Table Row ToVariable Loop Start Excel Reader Loop End String To Number Missing Value Row Filter GroupBy List Files/Folders Table Row ToVariable Loop Start Excel Reader Row Filter Loop End Missing Value Row Filter String To Number GroupBy Column Rename Column Rename Joiner Math Formula Column Resorter List Files/Folders Row Filter Math Formula Missing Value Decompress Files Download data from link in the challenge.Store in the data folder in the workflow andthen run the Decompress Files node, You'llneed to reset the input file path. Loop Over FilesRead SheetsCostRemove Rowsw/ No ChargesRemove CaptionRowsCalculate Mean& Std. DeviationSutterLoop OverFilesRead FilesExclude TempFilesRemove Rowsw/ No ChargesRemove CaptionRowsCostCalculate Mean& Std. DeviationAdd CorrectColumn HeadersAdd CorrectColumn HeadersJoin Kaiser& Sutter Databy Procedure(Default - matchingrows)SutterMean / Std DevFinal TableNode 38Node 39KaiserMean / Std DevStrings =blanksNumbers = 0(Used when doingright or left joins)Node 43Table Row ToVariable Loop Start Excel Reader Loop End String To Number Missing Value Row Filter GroupBy List Files/Folders Table Row ToVariable Loop Start Excel Reader Row Filter Loop End Missing Value Row Filter String To Number GroupBy Column Rename Column Rename Joiner Math Formula Column Resorter List Files/Folders Row Filter Math Formula Missing Value Decompress Files

Nodes

Extensions

Links