Challenge #19: Excel Record Locator

[gdybowski001]

Done

[gdybowski001]

Done

[BenoitC]

Completely missed the target here, very interesting challenge

[benjamin_feuchter]

Spoiler

[DennisK]

Attached solution

[mgaronson]

I took a completely different tact than the solution. I also tried it using the methodology of the solution. Both worked.

[josh_dykstra]

done!

[gabrielpereira]

Solution

[Jon-Knepper]

Spoiler

It took me a bit to figure out that you can just use that wild card character to bring in multiple files.  I thought it would be more complicated than that :).  this was a great exercise!

[fluteman]

At a high level, used the wildcard to bring all files starting with the name book*.xls

Then I sampled the first 8 rows of each file.

Then I tagged a recordId to each record.

Created formula  to identify the intrafile row count.

Split out row 1 and row 7.

-- noticed the title row of each file was considered row 1.... 

Then renamed

Applied a join to bring the values toegther using filename as a join.