Two new objects - a table and a function which creates some temporary tables and populates them with data to assemble the final data set to go into the new table.
Creates an intermediate temporary table to hold optimised food composition according to which food composition table (FCT) is most appropriate by distance from household location, but based on a distinct set of prioritised FCT lists, to optimise performance.
Populates a new table by joining household and individual consumption data to the intermediate table, based on the FCT list.
General Checklist
[ x] Database objects and columns have comments (or not applicable)
[ x] The project README.md has been updated to reflect any changes (or not applicable)
Two new objects - a table and a function which creates some temporary tables and populates them with data to assemble the final data set to go into the new table.
General Checklist