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

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.

Mubar's avatar
Mubar
Advocate 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