Carriage Returns in Data - Creating New Rows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Does anyone know how I can handle this situation so there is no new row within Alteryx?
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Thanks again everyone. 🙂
Cheers,
Mon
- « Previous
-
- 1
- 2
- Next »