Icon

User Wise Report test2

Data Processing (1st Step) Variable Creation (2nd Step) Writing the data to P2P Queries and T&E Queries Sheets as per the condition (3rd Step) Looping through variable and coping the template (5th Step) Formatting Header (4th Step) Read inputfile892readuser list5missing LEQRfilegroup by LEQRLEQR loopSort LEQRfilter rows as per variabledatatransformationfilter otherDCTfilter T&EDCTsort columnssort columnsfilter other thanT&E rowsfilter T&Erowswrite toT&E Querieswrite toP2P Queriesloop end46merging variablestemplate fileselectionfile creatorfile path &templatesource URIsource URINode 4713sheet selection107123sheet selection456910Node 90Node 91ValueNode 93 Excel Reader (XLS) XLS ControlTable Generator XLS BackgroundColorizer Rule Engine Excel Reader (XLS) XLS Font Formatter Excel SheetAppender (XLS) GroupBy Table Row ToVariable Loop Start Sorter Row Filter Metanode Column Filter Column Filter Column Resorter Column Resorter Nominal ValueRow Filter Nominal ValueRow Filter Excel SheetAppender (XLS) Excel SheetAppender (XLS) Variable Loop End XLS Cell Formatter XLS BackgroundColorizer Merge Variables Local File BrowserConfiguration Create File Name Variable toTable Row String to URI String to URI Copy/Move Files XLS ControlTable Generator XLS ControlTable Generator XLS Sheet Selector XLS SheetProperties Rule Engine XLS ControlTable Generator Rule Engine XLS ControlTable Generator XLS Sheet Selector XLS Cell Formatter XLS Font Formatter XLS BackgroundColorizer XLS BackgroundColorizer XLS SheetProperties XLS ControlTable Generator Rule Engine String To Number XLS ControlTable Generator Data Processing (1st Step) Variable Creation (2nd Step) Writing the data to P2P Queries and T&E Queries Sheets as per the condition (3rd Step) Looping through variable and coping the template (5th Step) Formatting Header (4th Step) Read inputfile892readuser list5missing LEQRfilegroup by LEQRLEQR loopSort LEQRfilter rows as per variabledatatransformationfilter otherDCTfilter T&EDCTsort columnssort columnsfilter other thanT&E rowsfilter T&Erowswrite toT&E Querieswrite toP2P Queriesloop end46merging variablestemplate fileselectionfile creatorfile path &templatesource URIsource URINode 4713sheet selection107123sheet selection456910Node 90Node 91ValueNode 93 Excel Reader (XLS) XLS ControlTable Generator XLS BackgroundColorizer Rule Engine Excel Reader (XLS) XLS Font Formatter Excel SheetAppender (XLS) GroupBy Table Row ToVariable Loop Start Sorter Row Filter Metanode Column Filter Column Filter Column Resorter Column Resorter Nominal ValueRow Filter Nominal ValueRow Filter Excel SheetAppender (XLS) Excel SheetAppender (XLS) Variable Loop End XLS Cell Formatter XLS BackgroundColorizer Merge Variables Local File BrowserConfiguration Create File Name Variable toTable Row String to URI String to URI Copy/Move Files XLS ControlTable Generator XLS ControlTable Generator XLS Sheet Selector XLS SheetProperties Rule Engine XLS ControlTable Generator Rule Engine XLS ControlTable Generator XLS Sheet Selector XLS Cell Formatter XLS Font Formatter XLS BackgroundColorizer XLS BackgroundColorizer XLS SheetProperties XLS ControlTable Generator Rule Engine String To Number XLS ControlTable Generator

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: ppadyala
Created at: 2020-06-07
On NodePit since: 2022-02-06
Last update: 2024-11-17
Created with KNIME version: v4.2.2

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

Try NodePit Runner!