Text to Column

[Vicky92]

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 ?

[ChrisTX · Accepted solution]

Can you post a screenshot of your Text to Columns configuration?  Which version of Designer are you using?

It works OK for me. I'm on version 2024.2

 

Chris

[caltang]

Usually what @ChrisTX showed is the standard. One thing about the Text-to-Column tool is, did you increase the column number manually and didn't confirm the entry? I sometimes find it stuck to an old number I placed in before confirming the number by clicking on the configuration panel until the text no longer changes in the settings.

[Vicky92]

Hi Team,

Sharing the working file (CSV), if you can help me with the solution. I have increased the length of string also. 

[Vicky92]

@caltang @ChrisTX Request your support on below query

[alexnajm]

@Vicky92 the configuration was given above, can you try it first and then show us what issues you are still having?

[caltang · Accepted solution]

I could do it without issue:

What seems to be the issue?

[aatalai · Accepted solution]

@Vicky92 don't get the error, but you can use the text to column to split it to rows and then transpose it

[Gaurav_Dhama_ · Accepted solution]

It would be much easier if you used text to column, split to rows then then cross tab it into columns. Don't forget to add a record ID to group by on, if you have multiple such records as rows.

[Vicky92]

Thanks a lot everyone!. It works.