Forum Discussion

lamorim's avatar
lamorim
Frequent Visitor
6 years ago
Solved

Split Column does not split all the data

Hi,   I am working with 3 csv files and have on a text column more than a million rows like this jornaldenegocios.pt/empresas/industria/detalhe/rei-dos-cogumelos-sob-suspeita jornaldenegocios.pt/...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi lamorim 

     

    You can add Custom Column like below, instead of splitting by delimiter.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi lamorim 

 

Some of the string and with "/" therefore it splits it into blank columns

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi lamorim 

     

    You can add Custom Column like below, instead of splitting by delimiter.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

     

    • lamorim's avatar
      lamorim
      Frequent Visitor
      6 years ago

      Thanks for your help.

       

      It worked.

       

      Do you thing that it is a bug from PowerBi?

       

       

       

      • Mariusz's avatar
        Mariusz
        Community Champion
        6 years ago

        Hi lamorim 

         

        No, as explained in the previous post, some of your strings end with "/" and this the delimiter you have used.

         

        Best Regards,
        Mariusz

        If this post helps, then please consider Accepting it as the solution.

        Please feel free to connect with me.
        LinkedIn