Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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