In the green table we fill in certain columns manually. Some columns (Fat, Protein) we want to get filled in from the blue table with PowerQuery. All entries have a unique ID, which match between the green and blue table.
The green table has formulas (ID) (is it ok with formulas in the table?)
Both tables grow during the day.
How can I get the missing values in the green table in column "Fat" and "Protein" from the blue table with PowerQuery? I know only the basics in PowerQuery.
You first need to build a query to read in the blue table. Set that to Load To / Only create connection - so it doesnt create a new table.
Then back in your main query, add a Merge Queries step. Select the 2 id columns as the matching columns. Next expand the column added by the Merge Queries step to add the Fat and Protein columns to your query - there will be an Expand/Aggregate button in it's column header.
You might also want to add Conditional Columns to choose either your original columns or the ones from the Merge Queries, then remove the original columns.
