Challenge #19: Excel Record Locator

[Pilsner]

My solution:

Spoiler

 

[dvaldez]

I really enjoyed this challenge.

I solved it using a batch macro. It iterates the specified coordinates for each file and outputs the results in a column that's based on the coordinates.

If the customer wants to add more coordinates, they can simply add more to the text input tool and it will append a new column.

Spoiler

Batch MacroWorkflow

[barrymoe]

Had to cheat to get the input file to work with the wildcard!! Kept using dynamic input and couldn't figure out how to tag the fileName to each record. 

Once I got that it was much easier!

[Daniel_Homola]

Here!

[jaredcoffin]

Way more long winded than the recommended. Should have taken advantage of the Multi-row rather than the RecordID tool. Book*.xls wasn't working well so file are separate.

[Will_Condon]

Great solution.

[Will_Condon]

My solutions prepping for Core Cert.

Spoiler

 

[jbatts]

Solution attached

[PuffinPanic]

Definitely took a slightly longer way round to get this solution, but as I tell my team, if it's giving the correct answer, then it's a correct solution.

[FlaviaNC_21]

Challenge #19 completed

Spoiler