Meet the Team: Ruth Amarteifio, Data School Coach
Get to know a bit more about the team working at The Information Lab!
A self-described ‘Master Jack-of-all-tradesman’, Ruth brings a multidisciplinary approach to learning and sharing ideas. Her background includes Architecture, Economics, Teaching and Tailoring.
In her own words:
I love change and solving problems. Every day is new and there is so much to learn, plan, and work on.
Ruth graduated from Architecture in Greenwich, Economics in Canterbury, Civil Engineering in Limerick, and a Bespoke Tailoring Diploma in London that included training on Savile Row. Before Joining the information lab, she was working on her fashion label Amartei.
When Ruth isn’t working, she can be found in her craft room- drawing, cutting or sewing, or risking her life down country hills on a road bike.
I have a scenario where I will frequently have to update a data source. Unfortunately, the data source isn’t live but instead is a static CSV file that I download/export from a third-party system. My process has been to download the CSV and add the date to the end of the file to help keep track. Here’s generic look at the CSV files:
Data_20180501.csv
Data_20180601.csv
Data_20180701.csv
etc.
I built my workbook using the first/original data source but now, when trying to replace/update the data source, I’m encountering an error because I created a combined field that doesn’t exist in the new data source (columns, etc. are all the same and won’t change)
what is the most efficient way to do so.