From the course: Advanced Scripting for Testers: Local Data, Spreadsheets, and Reporting

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Challenge: Consolidate multiple data sources

Challenge: Consolidate multiple data sources

From the course: Advanced Scripting for Testers: Local Data, Spreadsheets, and Reporting

Start my 1-month free trial Buy for my team

Challenge: Consolidate multiple data sources

“

(bright music) - [Instructor] We've seen how to work with both Excel and Google Spreadsheets, and now it's time for you to roll up your sleeves and try it out for yourself. So in this challenge, what I want you to do is try to pull together data from multiple sources and put it all into one file. So what we're going to do is build on this file from the last challenge that we had, and I've included a copy of that file in the exercise files for this video. What we're going to do is add another column here called New Bugs Opened or something like that. And the data for this column is going to come from this Google spreadsheet. You won't be able to open this one by name since it's not explicitly shared with you, but it is publicly available. And so you should be able to use the open by URL. I have included this URL for you in the initial script that you can find in the exercise files, such, you don't need to type it all out by hand. What you'll need to do is take all these created at…

Contents