Alteryx Designer Discussions

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

Carriage Returns in Data - Creating New Rows

MonBrazier
8 - Asteroid

Please help! Hopefully this is an easy one!

 

I have a tab delimited csv file that contains carriage returns within a particular field.

Unfortunately this comes through a new row within Alteryx.

 

MonBrazier_0-1590970251835.png

 

MonBrazier_1-1590970251844.png

 

Does anyone know how I can handle this situation so there is no new row within Alteryx?

 

Thanks!

10 REPLIES 10
MonBrazier
8 - Asteroid

Thanks everyone 🙂

 

I thought I might share the solution.

 

It was an adaptation of your brilliant suggestions - thank you very much.

The only additional mechanism I needed to add in was a way to dynamically set the number of columns to split by (so that all files we receive can have carriage returns removed).

 

Here is an excellent link here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Parsing-Data-with-Unknown-Number-of...

This helped determine how to do that.

 

 

MonBrazier_0-1591049693221.png

 

Thanks again everyone. 🙂

 

Cheers,

 

Mon

 

 

Labels