Challenge #19: Excel Record Locator

[KLTerrell]

I think this could have been simpler? My first attempt using crosstab didn't get me where I wanted to go, so I went with the tile > summarize approach. At least it works!

Spoiler

 

[JS1989]

Solution

[alycar]

A nice quick challenge!

[Dominic_Brady]

Wildcard Union and row id (restarting for each unioned table). Cool challenge.

[JBevan89]

Great Challenge.  My Solution attached.

[martinson]

XLS files don't seem to like Alteryx very much

[TGreen]

Challenge solved with dynamic input.

[KCooper]

#19

[s_wright]

Solved challenge_19 attached.