Icon

Wayne_​Enterprises_​Datapreparation

Orders_USCA _2015Orders_USCA_2016Orders_USCA_2017Orders_USCA_2018Orders_LATMOrders_APACjoins different datasets of 1 regioncombines east, west, north and south into 1 region Removes the null value from Order IDcombines east, west, north and south into 1 region Orders_EUcorrects misspelled region namescorrects misspelled region namescombines 2 corrected data sourceRenamesProduct nameto productfilters out nullOrder IDConverts null value to 0 in discount categoryConverts number(date, mon, year) into stringcombines year, mon, date to 1 columnConverts string into order dateconverts date, mon and year into 1 columnConverts string into date formFilters out only delivery date columnAdds the created date columnRemoves unwanted columnsremoves string values in sales dataConverts data type of salesfrom string to doublecombines east, west, north and south into 1 region Returns note excelSplits the return note column into many columnsRemoves theextra calculatedfieldRenames the reurn notes and Employee's nameRight outer Joints on 2 data sourcesUnwanted columns areremovedFile exported as ExcelConverts data type of salesfrom string to doubleJoins all the datasetsFile Reader File Reader File Reader File Reader File Reader Excel Reader (XLS) Concatenate String Manipulation Row Filter String Manipulation Excel Reader (XLS) String Replacer String Replacer Concatenate Column Rename Row Filter Missing Value Number To String Column Combiner String to Date/Time(legacy) Column Combiner String to Date/Time(legacy) Column Filter Column Appender Column Filter String Manipulation String To Number String Manipulation Excel Reader (XLS) Cell Splitter Column Filter Column Rename Joiner Column Filter Excel Writer (XLS) String To Number Concatenate Orders_USCA _2015Orders_USCA_2016Orders_USCA_2017Orders_USCA_2018Orders_LATMOrders_APACjoins different datasets of 1 regioncombines east, west, north and south into 1 region Removes the null value from Order IDcombines east, west, north and south into 1 region Orders_EUcorrects misspelled region namescorrects misspelled region namescombines 2 corrected data sourceRenamesProduct nameto productfilters out nullOrder IDConverts null value to 0 in discount categoryConverts number(date, mon, year) into stringcombines year, mon, date to 1 columnConverts string into order dateconverts date, mon and year into 1 columnConverts string into date formFilters out only delivery date columnAdds the created date columnRemoves unwanted columnsremoves string values in sales dataConverts data type of salesfrom string to doublecombines east, west, north and south into 1 region Returns note excelSplits the return note column into many columnsRemoves theextra calculatedfieldRenames the reurn notes and Employee's nameRight outer Joints on 2 data sourcesUnwanted columns areremovedFile exported as ExcelConverts data type of salesfrom string to doubleJoins all the datasetsFile Reader File Reader File Reader File Reader File Reader Excel Reader (XLS) Concatenate String Manipulation Row Filter String Manipulation Excel Reader (XLS) String Replacer String Replacer Concatenate Column Rename Row Filter Missing Value Number To String Column Combiner String to Date/Time(legacy) Column Combiner String to Date/Time(legacy) Column Filter Column Appender Column Filter String Manipulation String To Number String Manipulation Excel Reader (XLS) Cell Splitter Column Filter Column Rename Joiner Column Filter Excel Writer (XLS) String To Number Concatenate

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: karti
Created at: 2020-05-17
On NodePit since: 2020-05-29
Last update: 2024-11-21
Created with KNIME version: v4.1.3

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

Try NodePit Runner!