community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Mulitple Columns Text to Rows?

Meteoroid

Hi - I have a dataset that looks like something like this, where each column has delimited values:

criterion onecriterion twocode
1,2,3,22,3,4,1ABC,REC,TVD,INJ

 

and I want it to be split up to look like this but can't figure out how to use the text to column tool correctly:

 

criterion onecriterion twocode
12ABC
23REC

3

4TVD
21INJ

 

I found a way that sort of works by using text to columns instead of text to rows but it involves knowing exactly how many values there are to split up which will not always be the case, since this is dynamic workflow that will be reading and joining files from a directory. I attached an example worrflow of the kind of dataset I want to split into rows. Please help me! Thank you in advance.

Alteryx Certified Partner

Hey @himaniyadav 

 

Not so straight forward, but it needs a bit of transpose, then text to columns, throw in a bit of multirow then crosstab!!

 

I've attached an example

 

Meteoroid

Thank you so much for the solution so quickly! I'm new to Alteryx and spent so long trying to work it out myself, haha.

Labels