Icon

User Wise Report test

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 4713Node 56Node 58Node 59Node 60Node 62Node 63Node 64Node 65sheet selection107123sheet selection45678910 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 List Files Table Row ToVariable Loop Start Send Email Cell Splitter Cell Splitter Column Filter Column Rename Variable Loop End 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 Rule Engine XLS ControlTable Generator XLS BackgroundColorizer XLS SheetProperties 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 4713Node 56Node 58Node 59Node 60Node 62Node 63Node 64Node 65sheet selection107123sheet selection45678910 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 List Files Table Row ToVariable Loop Start Send Email Cell Splitter Cell Splitter Column Filter Column Rename Variable Loop End 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 Rule Engine XLS ControlTable Generator XLS BackgroundColorizer XLS SheetProperties

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-04-27
Created with KNIME version: v4.2.1

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

Try NodePit Runner!