Page 3 of 3 FirstFirst 1 2 3
Results 21 to 23 of 23

Thread: Power Query Challenge 5

  1. #21
    Acolyte albertan's Avatar
    Join Date
    Nov 2017
    Location
    Canada
    Posts
    24
    Articles
    0
    Excel Version
    2013


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

    Quote Originally Posted by Bill Szysz View Post
    This is only for fun solution :-))

    Bill, I like your solution a lot from the execution perspective did you have to do several steps and then merged them all in one step called "Result". Any tips are appreciated.

  2. #22
    Acolyte pinarello's Avatar
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    36
    Articles
    0
    Excel Version
    Office 365

    Challenge 5 - completely dynamic solution

    Hello,

    with what I learned from the solutions to this challenge, I was now able to develop a completely dynamic solution.

    Up to a length of 15-digit (expandable) IDs, the from/to range is automatically recognized and the list of new IDs is generated.

    For this purpose I determine from and to which position "From" and "To" are different.

    Please note that the IDs from 1000 to 3000 are only different at the first position and therefore only the IDs 1000, 2000, 3000 are generated.

    Furthermore, the restriction applies here as well, that for the generation of alphabetical IDs, from and to, may only differ at one position.
    Attached Files Attached Files

  3. #23
    Acolyte pinarello's Avatar
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    36
    Articles
    0
    Excel Version
    Office 365
    Hello,

    because I didn't like the restriction that from 1000 to 3000 only the IDs 1000, 2000, 3000 are generated.

    Therefore I extended the query to determine the length of numbers. So now all IDs between 1000 and 3000 are created as well.
    Attached Files Attached Files

Page 3 of 3 FirstFirst 1 2 3

Posting Permissions

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