Hi Team,
I need help with Text to column formula.
I have one column but the data is not getting split into columns correctly. I have to split the data into 100 columns from one column. While Alteryx is restricting to 26 columns only.
I have my all data into one column. Deliminator is "|"
"H|1235|GHYyyy|ghyiii|hjknnll|RTYUIO|GHLPIU|TY | YU | Yu | Yu | UI_9| HJI | YUIOO | UIO | UI| Ui| UI | UI | UI | UI | UI | YU | UI | UI | UI | UI | Ui | UI | UI | Ui | UI | UI | UI | UI | UI | UI | UI UI | UI | UI | UI | UI | UI | Ui | UI | JUI | Ui | Ui | Ui | UI | Ui | UI | UI | UI | UI | UI | UI | UIO | IO | Io | Io | Io | Io | IO | Io | Io_I | Uio | UIO | IOP |
Is their any limitation in terms of characters while converting text to Column ?
