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 ...
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

serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution 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
    Icon for Advocate I rankAdvocate 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
      Icon for Super User rankSuper 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.

      • Mubar's avatar
        Mubar
        Icon for Advocate I rankAdvocate I
        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