Icon

Financial _​ Product Differentials from Retail

Financial _ Product Differentials from Retail
Merge DATA + Custom Report Format (any desired granularity)Aggregated by 'PRODUCT_Category': Define a CustomReport: CustomizeReporting ColumnNames: Calculate Differentials by PRODUCT_Category: Sort Reporting Columns Ordered by Chronology: Missing Handling: Calculate Differentials: Sales CountsReport: DifferentialsReport: Authentication toGoogle Services/My Drive/KNIME_publicTransactionsfrom RetailDATAReport GranularityExtract Year and MonthFormatDatesFormat DatesExtract Year and MonthReportMerging IDReport Merging IDAddress Report to Data RowsMonthly Quantityby PRODUCT_CategoryTotal Quantity by PRODUCT_CategoryLoop Group byPRODUCT_CategoryCustomize Reporting Column NamesReporting Number toStringApply ChronologyForward Aggregationw.2 Steps WindowCalculate DifferentialsArrange Report to WIDEComplete Report Cloumns14 Sorted ReportingColumn NamesMerge Total CountsChronology Column NamesSort by ChronologyKeepNumericAppend Missed RowsAddress '0'to Missed QuantitiesLooped Item ...Missing Out... to VariableAddress Looped ItemDifferentialsCollectPRODUCT_CategoryArrange Report to WIDEMergeTotal CountsCountsPre-ProcessedDATA byPRODUCT_CategorySort Headersfrom LONGQuantitiesSort Headersfrom LONGDifferentials GoogleAuthentication Google DriveConnector CSV Reader CSV Reader Extract Date&TimeFields String to Date&Time String to Date&Time Extract Date&TimeFields Math Formula Math Formula Joiner GroupBy GroupBy Group Loop Start String Manipulation Number To String Sorter Moving Aggregation Math Formula Pivoting Table Creator Concatenate Joiner GroupBy Sorter String To Number Joiner Missing Value GroupBy Rule-basedRow Filter Table Rowto Variable ConstantValue Column RowID Loop End (2 ports) Pivoting Joiner RowID RowID ReferenceColumn Resorter ReferenceColumn Resorter Merge DATA + Custom Report Format (any desired granularity)Aggregated by 'PRODUCT_Category': Define a CustomReport: CustomizeReporting ColumnNames: Calculate Differentials by PRODUCT_Category: Sort Reporting Columns Ordered by Chronology: Missing Handling: Calculate Differentials: Sales CountsReport: DifferentialsReport: Authentication toGoogle Services/My Drive/KNIME_publicTransactionsfrom RetailDATAReport GranularityExtract Year and MonthFormatDatesFormat DatesExtract Year and MonthReportMerging IDReport Merging IDAddress Report to Data RowsMonthly Quantityby PRODUCT_CategoryTotal Quantity by PRODUCT_CategoryLoop Group byPRODUCT_CategoryCustomize Reporting Column NamesReporting Number toStringApply ChronologyForward Aggregationw.2 Steps WindowCalculate DifferentialsArrange Report to WIDEComplete Report Cloumns14 Sorted ReportingColumn NamesMerge Total CountsChronology Column NamesSort by ChronologyKeepNumericAppend Missed RowsAddress '0'to Missed QuantitiesLooped Item ...Missing Out... to VariableAddress Looped ItemDifferentialsCollectPRODUCT_CategoryArrange Report to WIDEMergeTotal CountsCountsPre-ProcessedDATA byPRODUCT_CategorySort Headersfrom LONGQuantitiesSort Headersfrom LONGDifferentials GoogleAuthentication Google DriveConnector CSV Reader CSV Reader Extract Date&TimeFields String to Date&Time String to Date&Time Extract Date&TimeFields Math Formula Math Formula Joiner GroupBy GroupBy Group Loop Start String Manipulation Number To String Sorter Moving Aggregation Math Formula Pivoting Table Creator Concatenate Joiner GroupBy Sorter String To Number Joiner Missing Value GroupBy Rule-basedRow Filter Table Rowto Variable ConstantValue Column RowID Loop End (2 ports) Pivoting Joiner RowID RowID ReferenceColumn Resorter ReferenceColumn Resorter

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: RE90273
Created at: 2021-12-17
On NodePit since: 2021-12-18
Last update: 2024-04-27
Created with KNIME version: v4.4.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!