Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 21

Thread: Power Query Challenge 5

  1. #11
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,343
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider


    Register for a FREE account, and/
    or Log in to avoid these ads!

    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)
    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #12
    Neophyte Nick_M's Avatar
    Join Date
    Jun 2019
    Posts
    1
    Articles
    0
    Excel Version
    365
    My solution
    IDGen - Nick M.xlsx

  3. #13
    Seeker Kolyu's Avatar
    Join Date
    Oct 2018
    Location
    Sofia, Bulgaria
    Posts
    14
    Articles
    0
    Excel Version
    2007, 2010, 2013, 2016
    Quote Originally Posted by bdarbonneau View Post
    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

  4. #14
    Seeker fshaikh's Avatar
    Join Date
    Nov 2018
    Location
    Saudi Arabia
    Posts
    6
    Articles
    0
    Excel Version
    Office365
    Quote Originally Posted by bdarbonneau View Post
    Attachment 9181A more brute-force approach than compared to that of fshaikh, but a solution still.
    I like your approach of generating the list.. good one..!!
    Last edited by fshaikh; 2019-06-20 at 09:21 AM.

  5. #15
    Seeker fshaikh's Avatar
    Join Date
    Nov 2018
    Location
    Saudi Arabia
    Posts
    6
    Articles
    0
    Excel Version
    Office365
    Quote Originally Posted by i__k View Post
    @fshaikh you can remove step 5, so there are 6 steps only
    woow !! didn't noticed about the ChangeType Step.. thanks for letting me know about it

  6. #16
    Seeker fshaikh's Avatar
    Join Date
    Nov 2018
    Location
    Saudi Arabia
    Posts
    6
    Articles
    0
    Excel Version
    Office365
    Quote Originally Posted by Kolyu View Post
    fshaikh, your solution is brilliant!
    Thanks Kolyu

  7. #17
    Acolyte Bill Szysz's Avatar
    Join Date
    Apr 2016
    Location
    Poznań, Poland Dublin, Ireland
    Posts
    99
    Articles
    0
    Excel Version
    Excel 365
    This is only for fun solution :-))
    Attached Files Attached Files

  8. #18
    Seeker BernardBrussels's Avatar
    Join Date
    Mar 2019
    Posts
    9
    Articles
    0
    Excel Version
    excel 365
    Hi,

    Discovered the game today...

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


    Bernard
    Attached Files Attached Files

  9. #19
    Seeker BernardBrussels's Avatar
    Join Date
    Mar 2019
    Posts
    9
    Articles
    0
    Excel Version
    excel 365
    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.

  10. #20
    Seeker BernardBrussels's Avatar
    Join Date
    Mar 2019
    Posts
    9
    Articles
    0
    Excel Version
    excel 365
    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....
    Attached Files Attached Files
    Last edited by BernardBrussels; 2019-06-25 at 03:44 PM.

Page 2 of 3 FirstFirst 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •