Challenge #64: Catch Me If You Can

[keng]

Interesting concept. I think a real world check / control would have the dynamic select do an inverse so you can see which columns were dropped and can investigate why they were not included in the Fields dataset. 

Spoiler

!contains([Name], " ")

[lewanark]

Spoiler

My solution...before I understood how much "Dynamic rename" tool can do:)

[BeginnerMindset]

Great challenge.

Spoiler

Update: I now realise from other posts that this would have been so much easier with a Dynamic Select after the Dynamic rename. We live and learn! 

[Hub119]

Solution attached... one output matches the "answer" file while the other keeps the area name field to allow the end user to understand which area the records are associated with.

[byagelski]

my solution...

[Shifty]

Slippery little devil.

Spoiler

[Maskell_Rascal]

Hardest part of the challenge was keeping the correct order for the headers. Fun challenge!

Spoiler

Cheers!

Phil

[apathetichell]

I decided to keep the Row ID...

[JasonHu]

Spoiler

Here is my submission, data structure is correct, but I want to know how to dynamic reorder those columns.

[Ajjay]

Soln