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

Alteryx designer Discussions

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

Splitting row into multiple

Asteroid

Hi Family,

 

I have a set of data that contains a column for "year". Most years just have one year listed but, if it has multiple years (e.g. 2017, 2018 & 2019), this row needs to become 3 rows with 2017 in the year column of one row, 2018 in another, and 2019 in the other. Does anyone know how I can achieve this?

Highlighted
Alteryx Certified Partner

Hi @AuditPro13 

 

Can you include a small sample of what your data might look like?

Will make it much easier to answer you questions.

Alteryx
Alteryx

Not sure if this is what you want your end result to look like but you can use the Text to column tool to split to rows using a delimiter. I attached a workflow example.

 

I hope this helps!

Asteroid

Hey! This is exactly what I need except I need multiple delimiters because my data looks like this: 2017, 2018 & 2019

Asteroid

@JordyMicheal do you know multiple delimiters works?

Asteroid

Hey! This is exactly what I need except I need multiple delimiters because my data looks like this: 2017, 2018 & 2019

 

Do you know multiple delimiter works?

Alteryx
Alteryx

You can add multiple delimiters in the field. Here is an updated workflow.

 

hope this helps!

Labels