Icon

forum 71917 - merging tabulated tables with priority

There has been no description set for this workflow's metadata.

FORECAST -3 FORECAST -2 FORECAST This part only required to put the ordered column headings back into M/d/yyyy format When columns get re-created by the Pivoting node, it will place them inascending order by text rather than by date, so will appear out ofsequence. We therefore need to make what will become the date columnvalues into a sortable name, so we will put them in yyyy/MM/dd format define a priorityvalue for each table.The newest tablewill be given priority1 Data preparation of Sample Data The sample data columns for table 3 were not the same as those in tables 1 and 2, so they need fixing Node 1Node 2Node 3priority 3(lowest priority)priority 2priority 1(highest priority)turn tabulated data to rows-basedbring everythingtogetherremove duplicateditems keeping only "lowest priority number"for each dateascending priority orderfirst rowused as column namesfirst rowused as column namesfirst rowused as column namesturn tabulated data to rows-basedturn tabulated data to rows-basedmake tablesamecolumn orderasother twoMake columnssame names asother tworename "Date"column for readabilityput result back tooriginal tabulatedformatset typesbecause demodata doesn't definethe typesconvert to Dateso it can then be converted torequired formatmake into a sortable date formatotherwise columnnames are goingto be out of sequencefor the datesget column namesfix column headingsback to original format.Split off the "date"columns from the othersmake a single column so wecan process itconvert into Dateso it can be easilyconverted to requiredformatconvert toM/d/yyyyfix column headersbring back togetherTable Creator Table Creator Table Creator ConstantValue Column ConstantValue Column ConstantValue Column Unpivoting Concatenate DuplicateRow Filter Sorter Row to ColumnHeader Row to ColumnHeader Row to ColumnHeader Unpivoting Unpivoting Column Resorter Column Rename Column Rename Pivoting Column AutoType Cast String to Date&Time Date&Time to String ExtractColumn Header Column Splitter Transpose String to Date&Time Date&Time to String Insert ColumnHeader Column Appender FORECAST -3 FORECAST -2 FORECAST This part only required to put the ordered column headings back into M/d/yyyy format When columns get re-created by the Pivoting node, it will place them inascending order by text rather than by date, so will appear out ofsequence. We therefore need to make what will become the date columnvalues into a sortable name, so we will put them in yyyy/MM/dd format define a priorityvalue for each table.The newest tablewill be given priority1 Data preparation of Sample Data The sample data columns for table 3 were not the same as those in tables 1 and 2, so they need fixing Node 1Node 2Node 3priority 3(lowest priority)priority 2priority 1(highest priority)turn tabulated data to rows-basedbring everythingtogetherremove duplicateditems keeping only "lowest priority number"for each dateascending priority orderfirst rowused as column namesfirst rowused as column namesfirst rowused as column namesturn tabulated data to rows-basedturn tabulated data to rows-basedmake tablesamecolumn orderasother twoMake columnssame names asother tworename "Date"column for readabilityput result back tooriginal tabulatedformatset typesbecause demodata doesn't definethe typesconvert to Dateso it can then be converted torequired formatmake into a sortable date formatotherwise columnnames are goingto be out of sequencefor the datesget column namesfix column headingsback to original format.Split off the "date"columns from the othersmake a single column so wecan process itconvert into Dateso it can be easilyconverted to requiredformatconvert toM/d/yyyyfix column headersbring back togetherTable Creator Table Creator Table Creator ConstantValue Column ConstantValue Column ConstantValue Column Unpivoting Concatenate DuplicateRow Filter Sorter Row to ColumnHeader Row to ColumnHeader Row to ColumnHeader Unpivoting Unpivoting Column Resorter Column Rename Column Rename Pivoting Column AutoType Cast String to Date&Time Date&Time to String ExtractColumn Header Column Splitter Transpose String to Date&Time Date&Time to String Insert ColumnHeader Column Appender

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: gabriel.mattos
Created at: 2023-08-16
On NodePit since: 2023-08-23
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!