Challenge #268: Definitely Not Made Up

[Shahbaz_analyst]

Spoiler

[Bobbyt23]

If I'm honest I didn't really understand the problem so used it as a learning opportunity and followed along to @PhilipMannering solution.

Spoiler

Loved these calculations: Padleft(tostring(RandInt([CountNonNull_City]-1)), 3, '0') never come across the RandInt one before so a good new one to learn.

[DanielG]

Solved.

Ugh.  This was ugly solution, but it works.

[rebecca_petter]

Done

[cmoussa]

[lwolfie]

Done

[JBevan89]

My Solution attached.

I suppose a good opportunity to test out the random function

[CeliaC_Silje]

Pretty straightforward approach - a macro should be required for the most dynamic handling.

[BS_THE_ANALYST]

Great Anonymisation Challenge. Spent time trying to dynamically change field types based on a lookup (nice to use a crew macro here). Spent time considering numeric vs non numeric (could extend this of course). I've got a lookup to unscramble the data if needed.

Spoiler

Time Taken: 30:29

[Pilsner]

My solution:

Spoiler