Which tool should I use?

mishail_iqbal

I have a table in an input file and want to distribute the values in one of its columns to new columns and remove data other than the first two answers.

The data looks like this in the column and is in one cell because it has been concatinated:

Ahmed, Ali, Ammar, Ayub

I want it to be Ahmed in one column and Ali in another and omit the last two. And of course do it for all records. 

Kenda

Hi @mishail_iqbal 

I would recommend using the Text to Columns tool for this case. It can be found in the Parse tool category. Pick the field that has your list in it and tell Alteryx the delimiter. Next just say you want to split the data into two columns and drop the remaining values. Like this:

Hope this helps!