We've got your metadata. Suppose the "SELECT COLUMNT TO SPLIT" question is considered by Alteryx and this happens:
- A field is selected because it contains similar \W (regex for non-word characters) patterns in the data (e.g. count of delimiters in the field are roughly equal).
- The delimiter (MODE delimiter or BEST) is defaulted
- Split # of columns = MODE count + 1
If a user updates the Field/Delimiter, the metadata could suggest the right Number of columns based upon the delimiter.
This all belongs in the automagically idea bank. It saves me the time of counting delimiters or trial and error counts.
Cheers,
Mark
