Create a yaml template to manually ingest cbbr_submissions data based of excel spreadsheet we received from strategic planning
To test, I ingested the data locally and viewed the csv files so that the data persisted as expected. In the original xlsx, a vlookup function was used to get key value pairs in certain columns which created invalid data when saving the file into a csv. To bypass this, I saved the values in the columns as they appeared (negating any need for a lookup).
Notes:
vlookup
function was used to get key value pairs in certain columns which created invalid data when saving the file into a csv. To bypass this, I saved the values in the columns as they appeared (negating any need for a lookup).