Row values to multiple columns

[rajatsaxena2105]

Hi all,

I have an input column for which each row can have up to 13 comma separated values. What i need to do is, have 13 columns corresponding to the 13 values and then have a "x" below each column header corresponding to the value in the given row. The example is as below

Input Data	Output Data col1	Output Data col2	Output Data col3	Output Data col4	Output Data col5	Output Data col6
BIL - Category	Reputational Damage	Public Finances	Legal Ramifications	Crime Fighting	Judicial Proceedings	Personal Safety of Citizens
Reputational Damage, Public Finances, Legal Ramifications	x	x	x
Crime Fighting, Judicial Proceedings, Reputational Damage, Personal Safety of Citizens	x			x	x	x
Judicial Proceedings, Reputational Damage	x				x
Reputational Damage	x

Can you please tell me how this can be done.

Best,

Rajat

[gnans19 · Accepted solution]

Using TextToColumns, Transpose, Append, Crosstab would do the trick. Attached workflow with my own data.

Note: In text to columns, I have also assumed number of columns as 13.

Hope this helps!

Regards,

Gnans

[KaneG · Accepted solution]

Similar approach to @gnans above. The key is to think about it in a different way. With Alteryx you can easily transform your data to perform a dynamic operation or a single operation over a dynamic number of fields.

Here's my similar answer (or set of)..

[rajatsaxena2105]

Thanks Kane, works perfectly! :)

Best,

Rajat

[rajatsaxena2105]

Hey @gnans19 I had to just insert a data cleansing tool before the unique tool and it works perfectly, thank you :)

Best,

Rajat