Forum Discussion

Mubar22's avatar
Mubar22
Frequent Visitor
2 years ago
Solved

Power Query Split by Column Each Occurrence giving error

Hi Devs

 

I want to split this column by comma, into each occurence to have it's respective column, but when i used the each occurence using comma as my delimiter, I only have two columns splitted when I was expecting like 50 columns.

Also, it shows this preview warning before returning splitted column. is there a way I can work around this.

 

Thanks,

Mubar

Data Protection
  • Mubar's avatar
    Mubar
    2 years ago

    It's working fine now, I used the advanced features to split it to 200 columns (it was 2 on default)

    Thanks

8 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    2 years ago

    Hi,

    please post some rows of your table in order to understand the problem

    • Mubar's avatar
      Mubar
      Advocate I
      2 years ago

      Here is content in the rows

       

       

      • serpiva64's avatar
        serpiva64
        Solution Sage
        2 years ago

        sorry, but if you paste using copy and paste the content of 3 or more cells instead of the image it is easier to try to solve (on the contrary i need to copy the content and it will me take a long time)  

  • serpiva64's avatar
    serpiva64
    Solution Sage
    2 years ago

    Hi,

    as you see i can't get your error and your data are splitted in 323 columns

     

     

    Maybe, at a certain point of your data you get some problem.

    Pay attention to the fact that the error isn't on split by column but in a further step you have created

     

    • Mubar's avatar
      Mubar
      Advocate I
      2 years ago

      This is what I'm having when I do it at my end

      I only have 2 columns splitted

      • ronrsnfld's avatar
        ronrsnfld
        Super User
        2 years ago

        I, also, get 323 columns splitting your data on the comma. Please go into the Advanced Editor and post your M-Code as text so we can examine it.