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

       

       

      • lamorim's avatar
        lamorim
        Frequent Visitor
        6 years ago

        It is strange because I tried to do it with "detalhe/" and the result was the same.

         

        Thanks again