Icon

Ecommerce

Read transactions L3MRead transactions HistoryRead Customer MDConcatenatetransactionsConvert IDto stringCalculatesalesAggregateby productSort bydecreasingsalesExclude'Others'categoryKeep top 10 onlyFor eachsubcategoryKeep top 3 onlyConvert datesAggregateby categoryand monthSort bydecreasing salesManagemissing valuesSave reportOnly for 2019Aggregate byCategoryCalculatetotal salesCreate variablewith totalCalculate footprintVisualize sales by monthAggregateby countrySaves chart imageLeft outer joinon customersInner join on productsExtract monthsRead product MDExcel Reader Excel Reader CSV Reader Concatenate Number To String Math Formula GroupBy Sorter Row Filter Row Filter Group Loop Start Row Filter Loop End String to Date&Time Pivoting Sorter Missing Value Excel Writer Date&Time-basedRow Filter GroupBy GroupBy Table Rowto Variable Math Formula Line Plot GroupBy Image Writer (Port) Joiner Joiner Extract Date&TimeFields CSV Reader Read transactions L3MRead transactions HistoryRead Customer MDConcatenatetransactionsConvert IDto stringCalculatesalesAggregateby productSort bydecreasingsalesExclude'Others'categoryKeep top 10 onlyFor eachsubcategoryKeep top 3 onlyConvert datesAggregateby categoryand monthSort bydecreasing salesManagemissing valuesSave reportOnly for 2019Aggregate byCategoryCalculatetotal salesCreate variablewith totalCalculate footprintVisualize sales by monthAggregateby countrySaves chart imageLeft outer joinon customersInner join on productsExtract monthsRead product MDExcel Reader Excel Reader CSV Reader Concatenate Number To String Math Formula GroupBy Sorter Row Filter Row Filter Group Loop Start Row Filter Loop End String to Date&Time Pivoting Sorter Missing Value Excel Writer Date&Time-basedRow Filter GroupBy GroupBy Table Rowto Variable Math Formula Line Plot GroupBy Image Writer (Port) Joiner Joiner Extract Date&TimeFields CSV Reader

Nodes

Extensions

Links