Forum Discussion

123abc's avatar
123abc
Community Champion
1 year ago
Solved

Mange Data in Excel with Power Query

Hi Experts:   I have a Gulfoods Catalogue  i wants to extrract the following Informaiton from it and wants to organizae it in excel 4 columns parallely like:   1.Comany Name 2.Tel 3.Email 4.We...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • BeaBF's avatar
    BeaBF
    1 year ago

    123abc Thank you so much for your kind words, I'm happy I was able to help you! Please accept the message above with the code as the solution, to assist other users as well!
    Regarding point 5, here's the explanation.

     

    I've used a M code that filters the table `"Added Index"` using `Table.SelectRows`, keeping only rows where:

    1. `Column1` contains "Tel:", "Email:", or "Website:".
    2. `Column1` is fully uppercase and not empty (`Text.Upper([Column1]) = [Column1] and [Column1] <> ""`).
    3. If none of the above applies, the row is ignored (`null`).

     

    BBF

BeaBF's avatar
BeaBF
Super User
1 year ago

123abc Sent! Then if this solution it's ok, please accept my previous message as solution.

 

BBF

123abc's avatar
123abc
Community Champion
1 year ago

Thank You Very Much .. Please let me check.

  • 123abc's avatar
    123abc
    Community Champion
    1 year ago

    I sincerely appreciate the time and effort you took to solve my Power BI issue related to Power Query and data extraction. Your solution was clear, precise, and incredibly helpful in resolving my challenge. It's always inspiring to see such willingness to share knowledge and expertise. Thank you for your valuable support and guidance. I hope to learn more from you in the future!

     

    I am just stcuk to understand step 5......😣

  • BeaBF's avatar
    BeaBF
    Super User
    1 year ago

    123abc Thank you so much for your kind words, I'm happy I was able to help you! Please accept the message above with the code as the solution, to assist other users as well!
    Regarding point 5, here's the explanation.

     

    I've used a M code that filters the table `"Added Index"` using `Table.SelectRows`, keeping only rows where:

    1. `Column1` contains "Tel:", "Email:", or "Website:".
    2. `Column1` is fully uppercase and not empty (`Text.Upper([Column1]) = [Column1] and [Column1] <> ""`).
    3. If none of the above applies, the row is ignored (`null`).

     

    BBF

  • 123abc's avatar
    123abc
    Community Champion
    1 year ago

    Thank You so much this has resolved now. I am bit confused on a little applied step # 5 Filtered Rows, after step # 4 in applied steps Added index, how you added this step # 5, I mean are you using add Column + Custom Column and adding Table.SelecRow(.....) M Function or using any other approach bcz i just stuck here ...! and onward, all steps i have understad wtih the help and guidence of you kind support.  Thank You Very Much again for your kind support.

     

    Regards 

    Ali Abbas