Split Column by Delimiter Advanced # of Columns is PRE-set to 2??

[kurwilliams]

I am wondering if anyone else has encountered this as it was a bit of a shock for me. I used the "split column by delimiter" feature and I was surprised that I only got two columns when I knew there should have been three. Turns out that under the "advanced" section the # of columns was pre-set to "2". Limiting the output, so even though I said split at each instance, it would only ever give me 2 columns. I went to several other areas I used this and it did the same thing! Is this a setting somewhere? How do I change the default value? I would prefer to have NO default there, and just get the correct number of columns for my data!

[m_dekorte · Accepted solution]

Hi @kurwilliams,

The issue is that the M engine scans only the top 200 rows to determine the number of columns. That cannot be adjusted as it is by design. When you know the number of columns a split column operation should produce and that number is fixed, you can update it manually.

However, when the number of columns is unknown or may vary other techniques can be used, one of those techniques is demonstrated here: Split by Variable Columns 

I hope this is helpful