Icon

ETL_​Solanablockchain_​data

The column filter filters the project_name, succeededcolumn and sales_amount.The two row filters filter the degods project andsuceeded transactions(true).The group by is used to group the sum ofsales_amount based on projects. The three mongo dbconnectors are used toget the data from threeteamates and mongo dbreader are used to readdatabase and json totable converts it intotable format. The two joiners are usedto combine this data setto combine all theattributes that weremissing and they arecombined at the output. The column filter filters project_name,suceededcolumn,sales_amount and timestamp columns of eachtransaction.The two row filters filter the degods project and suceededtransactions(true).The string to time to data/time converts the date string to timeformat and splits date into month and year.The group by is used to group the projects based on the sumof sales_amount month wise using sorter.The line plot visualises month wise sales. The column filter filters project_name,suceededcolumn,sales_amount , seller columns of each transaction.The two row filters filter the degods project and suceededtransactions(true).The group by is used to group the sellers based on sum ofsales_amount.The top-k selector and sorter sorts and filters only the top 10 sellers.The bar chart visualises the same. The column filter filters project_name,suceededcolumn,sales_amount , purchasers columns of each transaction.The two row filters filter the degods project and suceededtransactions(true).The group by is used to group the purchasers based on sum ofsales_amount.The top-k selector and sorter sorts and filters only the top 10purchasers.The bar chart visualises the same. The column filter filters project_name,suceededcolumn,sales_amount , market_place columns of each transaction.The two row filters filter the degods project and suceededtransactions(true).The group by is used to group the market places based on sum ofsales_amount.The top-k selector and sorter sorts and filters only the top 10 marketplaces.The bar chart visualises the same. GamanashNode 2Node 3VineetNode 5Node 6Node 7KarthikNode 9Node 10Node 11Node 12Node 13Node 15Node 16Node 17Node 18Node 19Node 20Node 21Node 22Node 23Node 25Node 26Node 27Node 28Node 29Node 30Node 31Node 32Node 33Node 34Node 35Node 36Node 37Node 38Node 39Node 40Node 41Node 42Node 43Node 44 MongoDB Connector MongoDB Reader JSON to Table MongoDB Connector MongoDB Reader JSON to Table MongoDB Reader MongoDB Connector JSON to Table Joiner Joiner Column Filter Row Filter GroupBy Scatter Plot Column Filter Row Filter Row Filter Row Filter Date FieldExtractor (legacy) String to Date/Time(legacy) GroupBy Sorter Column Filter Row Filter GroupBy Bar Chart Top k Selector Sorter Column Filter Row Filter GroupBy Bar Chart Top k Selector Sorter Column Filter Row Filter GroupBy Bar Chart Top k Selector Sorter Line Plot The column filter filters the project_name, succeededcolumn and sales_amount.The two row filters filter the degods project andsuceeded transactions(true).The group by is used to group the sum ofsales_amount based on projects. The three mongo dbconnectors are used toget the data from threeteamates and mongo dbreader are used to readdatabase and json totable converts it intotable format. The two joiners are usedto combine this data setto combine all theattributes that weremissing and they arecombined at the output. The column filter filters project_name,suceededcolumn,sales_amount and timestamp columns of eachtransaction.The two row filters filter the degods project and suceededtransactions(true).The string to time to data/time converts the date string to timeformat and splits date into month and year.The group by is used to group the projects based on the sumof sales_amount month wise using sorter.The line plot visualises month wise sales. The column filter filters project_name,suceededcolumn,sales_amount , seller columns of each transaction.The two row filters filter the degods project and suceededtransactions(true).The group by is used to group the sellers based on sum ofsales_amount.The top-k selector and sorter sorts and filters only the top 10 sellers.The bar chart visualises the same. The column filter filters project_name,suceededcolumn,sales_amount , purchasers columns of each transaction.The two row filters filter the degods project and suceededtransactions(true).The group by is used to group the purchasers based on sum ofsales_amount.The top-k selector and sorter sorts and filters only the top 10purchasers.The bar chart visualises the same. The column filter filters project_name,suceededcolumn,sales_amount , market_place columns of each transaction.The two row filters filter the degods project and suceededtransactions(true).The group by is used to group the market places based on sum ofsales_amount.The top-k selector and sorter sorts and filters only the top 10 marketplaces.The bar chart visualises the same. GamanashNode 2Node 3VineetNode 5Node 6Node 7KarthikNode 9Node 10Node 11Node 12Node 13Node 15Node 16Node 17Node 18Node 19Node 20Node 21Node 22Node 23Node 25Node 26Node 27Node 28Node 29Node 30Node 31Node 32Node 33Node 34Node 35Node 36Node 37Node 38Node 39Node 40Node 41Node 42Node 43Node 44MongoDB Connector MongoDB Reader JSON to Table MongoDB Connector MongoDB Reader JSON to Table MongoDB Reader MongoDB Connector JSON to Table Joiner Joiner Column Filter Row Filter GroupBy Scatter Plot Column Filter Row Filter Row Filter Row Filter Date FieldExtractor (legacy) String to Date/Time(legacy) GroupBy Sorter Column Filter Row Filter GroupBy Bar Chart Top k Selector Sorter Column Filter Row Filter GroupBy Bar Chart Top k Selector Sorter Column Filter Row Filter GroupBy Bar Chart Top k Selector Sorter Line Plot

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: karthikrpatil
Created at: 2022-12-04
On NodePit since: 2022-12-29
Last update: 2024-11-21
Created with KNIME version: v4.6.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!