Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to split row by newline

Sshasnk
8 - Asteroid

Hi I have a dataset wherein a cell I have multiple values in newline but I have to pick the last value example below

 

If you will see in quantity last value was 234 and in price 45.12 but in rate there was no value in next line so I left

Input:

Idqualitypricerate
XDFE123

123

234

10.23

45.12

0.35%
DKSL123124785

0.25%

0.45%

0.21%

SDALF456

145

12456

145

47.21

14725

147.23

0.21%
ASDFLZ12341234570.23%

 

Output:

Idqualitypricerate
XDFE123

234

45.12

0.35%
DKSL123124785

0.21%

SDALF456

145

147.23

0.21%
ASDFLZ12341234570.23%
5 REPLIES 5
Emil_Kos
17 - Castor
17 - Castor

Hi,

 

You need to use text to column and pick /n as a delimiter.

 

I have prepared a workflow as an example. 

 

Please mark my post as a solution if this was helpful!

Sshasnk
8 - Asteroid

@Emil_Kos  I think you have pasted the data wrong in input text

phottovy
13 - Pulsar
13 - Pulsar

Try the attached workflow and see if it gives you what you need.

Amin
8 - Asteroid

Hi @Emil_Kos , you mean \n instead of /n.

 

Tried your solution and worked on a problem I was trying to solve! Thanks!

Emil_Kos
17 - Castor
17 - Castor

Hi @Amin,

 

yes of course 😅 glad that this helped!

Labels