Power Query Challenge 5

That was an interesting challenge.
My solution follows the same approach as Ken's but I did it in one single query.
 

Attachments

  • IDGen - Kolyu.xlsx
    22.2 KB · Views: 68
Haha! Whoops! I just replaced the file with one WITHOUT my queries, which was my original intention. Blew my own challenge here!

I'll upload mine tomorrow. ;)
 
Hi Ken, follow my solution. I'm from Brazil... and starting to learn Power Query (there are many steps). Good challenge. Thanks.
 

Attachments

  • IDGen_Julio.xlsx
    18.3 KB · Views: 41
Last edited:
Nice challenge, Ken! Enjoyed it.
 

Attachments

  • ExcelGuru_Challenge05_RonCoderre.xlsx
    17.6 KB · Views: 55
Hi Ken, Check out my solution. Interesting Challenge & slightly tricky, but enjoyed cracking the solution. Best thing managed to wrap it up in 7 steps :yo:
waiting to see your solution upload :canada:

Regards, Faraz Shaikh
 

Attachments

  • IDGen_FarazShaikh.xlsx
    21.7 KB · Views: 105
@fshaikh you can remove step 5, so there are 6 steps only:):)
 
View attachment PQ_Challenge5.pbix
find my attempt, I used power query on Power BI for this

I used two methods

Version 1 was my original attempt
Julio V2 was my second method making use of one of @juliomachado92 step
 
There's some cool solutions there! I've attached mine, which was focused on readability and maintainability for a new-to-power-query user. (In our workshop we did cover {1..10} style lists, but that was by far the deepest we went, as everything else was UI driven)
 

Attachments

  • IDGen - Solution.xlsx
    21.3 KB · Views: 135
A more brute-force approach than compared to that of fshaikh, but a solution still.

The way you replaced null values using = Table.ReplaceValue(Source,null,each _[From],Replacer.ReplaceValue,{"To"}) was interesting

It is efficient but I still can not explain to myself how it works
 
Hi,

Discovered the game today...

So I lets see for the fun...
Best way to learn is to try...


Bernard
 

Attachments

  • Challenge5.xlsx
    24.2 KB · Views: 9
Now that my answer has been posted, I have been reading proposed solutions...

learned:
- Creation of a list from characters... {[From3.2]..[To3.2]} (with [From3.2] &[To3.2] as text )
- Merging columns: this is beter as columns vanish in the process


regards & thanks for the challenge

Bernard.
 
Hello the Forum,

Integrated the leaned process... & went one step further:

I don't separate numbers & letters....

I created an index that count from 001 to 999 and from 00A to ZZZ....
 

Attachments

  • IDGen - Bernard.xlsx
    22.9 KB · Views: 17
Last edited:
Back
Top