Icon

Challenge 02 - July

Loading the base data from the HUB

External price data

Picture links for the dashboard

Calculations of the nutritients

Put the data into a dashboard

Read the macros datafood_macros_clean.csv
CSV Reader
Lookupthe values
Value Lookup
Mergethe twocolumns
Column Merger
TOP5 bestprotein per dollarFood Items
Top k Row Filter
Protein per dollar:Protein/price_per_100g_dollar
Math Formula
Ingredient pictures
Table Creator
Put theimagesinto the table
Joiner
Downloadthe images
Image Reader (Table)
Best food by proteinper dollar
Top k Row Filter
Read the prices datafood_prices_clean.csv
CSV Reader
Best 2 food by proteinper dollar
Top k Row Filter
Best food by proteinper dollar
Top k Row Filter
Get the priceto the food
Joiner
Visualization
Proper caseto food name
String Manipulation
Deduplicateby food item(mean macros)
GroupBy
Meal picture
Table Creator
Put theimagesinto the table
Joiner
Carbonhydrate itemsType="Grains, Breads & Starches"<50 g Carbs
Row Filter
Protein items >25 g protein< 5 g fatType = "Proteins"
Row Filter
Downloadthe image
Image Reader (Table)
Connect tothe appropriatespace
Space Connector
Concatenatejust the optimalitems
Concatenate
Authenticateto KNIME Hub
KNIME Hub Authenticator
Vegetable items<100 KcalType = "Vegetables & Fungi"
Row Filter
Price for missing items
Table Creator

Nodes

Extensions

Links