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 (4th Step) Read inputfilereaduser listmissing LEQRfilegroup by LEQRLEQR loopSort LEQRfilter rows as per variablefile creatordatatransformationfilter otherDCTfilter T&EDCTsort columnssort columnsfilter other thanT&E rowsfilter T&Erowswrite toT&E Querieswrite toP2P Queriesloop endNode 39 Excel Reader (XLS) Excel Reader (XLS) Excel SheetAppender (XLS) GroupBy Table Row ToVariable Loop Start Sorter Row Filter Create File Name Metanode Column Filter Column Filter Column Resorter Column Resorter Nominal ValueRow Filter Nominal ValueRow Filter Excel SheetAppender (XLS) Excel SheetAppender (XLS) Variable Loop End Merge Variables 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 (4th Step) Read inputfilereaduser listmissing LEQRfilegroup by LEQRLEQR loopSort LEQRfilter rows as per variablefile creatordatatransformationfilter otherDCTfilter T&EDCTsort columnssort columnsfilter other thanT&E rowsfilter T&Erowswrite toT&E Querieswrite toP2P Queriesloop endNode 39Excel Reader (XLS) Excel Reader (XLS) Excel SheetAppender (XLS) GroupBy Table Row ToVariable Loop Start Sorter Row Filter Create File Name Metanode Column Filter Column Filter Column Resorter Column Resorter Nominal ValueRow Filter Nominal ValueRow Filter Excel SheetAppender (XLS) Excel SheetAppender (XLS) Variable Loop End Merge Variables

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.1.3

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

Try NodePit Runner!