Icon

Flujo Costo de servir

In this workflow, you'll read, combine, clean, and summarize data from multiple Excel sheets. You'll calculate the total volume of furniture when moving from one apartment to another.

Flujo Distribucion final Costo de servir

Read the first sheet ("Distribucion Fullfilment 2026")of the 1. Distribucion Fulfilment 2026 H1.xlsx file
Excel Reader
Read the first sheet ("Distribucion Go to Market")of the 2. Distribución Go to Market 2026 H1.xlsx file
Excel Reader
Constant Value Column Appender
GroupBy
Renombra a la columna Acumulado
Column Renamer
Column Renamer
Agrega la columna % Participacion Acumulado
Moving Aggregator
Total Costo de servir de las 3 categorias
Math Formula
Constant Value Column Appender
Read the first sheet ("Rebates") Rebates.xlsx file
Excel Reader
Joiner
Math Formula
Exportar el archivo a Excel
Excel Writer
Column Filter
Joiner
Regla tipo de cliente
Rule Engine
Los valores nulos son equivalentes a 0
Missing Value
Renombra a la columna Acumulado
Column Renamer
Includes: ID CLIENTE LEASINGNOMBRE CLIENTE LEASINGEquipo RegionalEquipos ComercialesNOMBRE AREA
Column Filter
Includes: ID CLIENTE LEASING,NOMBRE CLIENTE LEASING,Equipo Regional,Equipos Comerciales,NOMBRE AREA
Column Filter
Union Base principal con Base de rebates
Joiner
Includes: ID CLIENTE LEASING,NOMBRE CLIENTE LEASING,Equipo Regional,Equipos Comerciales,NOMBRE AREA
Column Filter
Agrega columna calculada utilidad con rebates
Math Formula
GroupBy
Rename "Costo de servir" for Costo de Servir fullfilment
Column Renamer
Agrega columna calculada utilidad costo de servir
Math Formula
Rename "Costo de servir" for "Costo de Servir GTM"
Column Renamer
Ordenar de mayor a menorpor la columna de Utilidad costo de servir
Sorter
Duplicate Row Filter
Column Renamer
Duplicate Row Filter
Total Utilidad Costo de servir
GroupBy
Duplicate Row Filter
Rename "Costo de servir" for "Costo de Servir Postventa"
Column Renamer
Agrega la columna Acumulado
Moving Aggregator
Joiner
Renombra a la columna Acumulado
Column Renamer
Los valores nulos son equivalentes a 0
Missing Value
Read the first sheet ("Distribucion Post venta")of the 3. Distribucion Postventa 2026 H1.xlsx file
Excel Reader
Los valores nulos son equivalentes a 0
Missing Value
Agrega columna calculada utilidad con rebates
Math Formula
Joiner

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: Emilio.Silvestri
Created at: 2023-02-17
On NodePit since: 2026-09-03
Last update: 2026-09-25
Created with KNIME version: v5.12.0
Tags: ExcelSpreadsheetdata wrangling

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

Try NodePit Runner!