Page 3 of 3 FirstFirst 123
Results 21 to 30 of 30

Thread: Merging UnEven Names in Power Query

  1. #21
    New Member montyfern's Avatar
    Join Date
    Oct 2017
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merging UnEven Names in Power Query

    ok, thanks to you both. For you sandy666, the worksheet is protected so I can't see the query. What's the password please? I think we're really close. However, I can't view the queries due to protection. But, they're two tables. ?

    For the German person, thanks so much! I tried to run your code but get an error "Expression.Error: The name 'Table.Tabelle24" wasn't recognized. Make sure it's spelled correctly."

    Thanks you both!

  2. #22
    New Member montyfern's Avatar
    Join Date
    Oct 2017
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merging UnEven Names in Power Query


  3. #23
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,329
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Merging UnEven Names in Power Query

    Expression.Error because your Excel PowerQuery version doesn't support Table.FuzzyNestedJoin() function
    Last edited by sandy666; Jun 7th, 2019 at 11:13 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  4. #24
    New Member
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    31
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merging UnEven Names in Power Query

    Very strange! That should have been called "Table245". But with me the query ran without problems. But now I have reworked it again and added the optional parameter "NumberOfMatches" for the join and assigned it the value 1.


    In the folder I also added a link to the Microsoft documentation.


    I hope you can now open the folder and execute the Power Query query without any problems.

    Here once more the actual link

  5. #25
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,329
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Merging UnEven Names in Power Query

    Table.Fuzzy* was released in October 2018 and Microsoft still didn't update it for all versions of Excel.
    It works for 2019 but not for any previous versions. I am not sure about 365
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  6. #26
    New Member
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    31
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merging UnEven Names in Power Query

    I use 365 and it works. By the way, a few years ago I programmed a fuzzy search myself that also takes synonym lists into account.

  7. #27
    New Member
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    31
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merging UnEven Names in Power Query

    If the Power Query of your Excel version does not yet support the table join with the fuzzy logic, then there is a very simple way.


    Install the free Power BI Desktop version and create the query there. When you have loaded the query, activate the table view, place your cursor in the table and choose the function "Copy table". Now switch to Excel and import the table using Cntrl+V.


    Copy and paste is necessary because the free Power BI Desktop version does not offer the possibility to save the query in a format that Excel can read and Excel is not able to read .pbix files.

  8. #28
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,329
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Merging UnEven Names in Power Query

    that is why PBI Desktop is very annoyed
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  9. #29
    New Member montyfern's Avatar
    Join Date
    Oct 2017
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merging UnEven Names in Power Query

    Yup, can't use Fuzzy Join. But @pinarello, I've copied all your info down when my co. updates. Great to know, & thanks for all your help & hard work! @ sandy666, much obliged. I'm not sure if she wants two tables but I can handle that. I too use PBI Desktop & a little Tableau. Will undoubtedly have more BI questions as my knowledge of DAX & PQ grows. Cheers! --montyfern

  10. #30
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,329
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Merging UnEven Names in Power Query

    You are welcome

    Have a nice day
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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