Challenge #19: Excel Record Locator

[KirstyHarvey]

Still trying to get my head around Multi Row formula!!

[fimler]

Started creating the Row # with the Record ID tool but quickly found that wasn't quite right.  Move to the Multi-Row and once I figured that out the rest fell in place....

[AnGi]

Done

[jfeldkamp123]

I dropped more tools in than most 😞

Might need to tweak if the scale of files is large and flow starts to lag - this flow ran in 1.2 sec, and I could see if there were thousands it might be a good idea to switch it up.

[troyeb4]

Flow below, solution attached. Good skill builder.

Spoiler

[Samanthaj_hughes]

🙂

[omercado05]

Came to the same solution as everyone else. That said, I tried at first to use the Record ID tool and a second later knew that wasn't going to work. Still trying to get comfortable with the Multi-Row tool and I realize how powerful it really is. Appreciated the skills this challenge was trying to build up.

[ehughes]

My solution

Spoiler

 

[matt_un]

Spoiler

Another nice use of the tile tool. It's very useful as a grouped version of record id.

[Tberney]

This really should have been easy but somehow it just wasn't.

I did not bother loading the new driver, just converted the files to .xlsx. And keep an eye out for the misleading numbering in the files

Spoiler