Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Split line breaks into separate rows

Meteor

Hello,

 

I'd like to split line breaks into separate rows from an Excel file so I can perform calculations. I'd like to transform this:

current.JPG

 

Into this:

desired.JPG

 

I've attached a sample file for reference. Any help would be greatly appreciated!

 

 

Thanks,

 

@mestevez 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @mestevez 

 

I don't have much time to detail the workflow right now, but I provided you a solution.


Take a look and if you have any questions let me know.

 

WF attached on version 2018.4

 

Cheers,

Highlighted
Meteor

Thank you for the awesome solution @Thableaus! That does exactly what I was looking for.

Highlighted
Meteor

Hi @Thableaus is there a way, you can send me this file in older version. I cannot open it in mine since I have 2018.3. Thanks!!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Sure @bb 

 

Here it goes. It's attached.


Cheers,

Labels