Icon

User Wise Report test_​ipazin

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 copying template file(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 endCopy Excel filewith new nameNode 41SourceURISelect template FileNode 47TargetURI 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 Copy/Move Files Variable toTable Row String to URI Local File BrowserConfiguration Merge Variables String to URI 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 copying template file(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 endCopy Excel filewith new nameNode 41SourceURISelect template FileNode 47TargetURIExcel 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 Copy/Move Files Variable toTable Row String to URI Local File BrowserConfiguration Merge Variables String to URI

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-21
Created with KNIME version: v4.2.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!