community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

embedded newlines

Meteor

Hi Team,

I have a Cell with 4 values in it.

AB
TestData1.0 Google
2.0 Yahoo
3.0 Amazon 

In Alteryx only first value is shown with a messgae: "This Cell has embeded newlines": 

I want an out put like:

AB
TestData1.0 Google
TestData2.0 Yahoo
TestData3.0 Amazon

 

How do I extract each Value from single cell and disply it in a separate row?

 

Thanks,

Rana

Alteryx Certified Partner
Alteryx Certified Partner

Hi @itahir04 

 

You can use the Text to Columns Tool with \n as a delimiter, and split that to rows.

 

TexttoColumns.PNG

 

Cheers,

 

 

Highlighted
Quasar
Quasar

Hello @itahir04 

 

I am unaware of any native way of pulling that value in all cells, but I looked at what Alteryx was doing when pulling those merged cells. It seems that the first cell is populated and the rest show as null. 

 

I have put in an example where we use the multirow tool in order to fill the nulls in with the values above using this formula.

 

if isnull([A]) then [Row-1:A] else [A] endif

 

See attached

Alteryx
Alteryx

Hey @itahir04 

 

Should be as easy as using a Text-to-Columns and splitting that field to rows, with a delimiter of \n for new lines.

 

Capture1.JPG

 

 
Meteor

Thank you So much!

Meteor

Hi Tyson,

Can you please drop the screenshot of the workflow. I can't open this workflow, as you seems to have latest version of alteryx.

 

Thank you for looking into this.

Regards,

Rana

 

 

Quasar
Quasar

To clarify, I think I misunderstood the original question. I thought you had a merged cell that you were trying to get the value of that merged cell into all the null cells that Alteryx reads it as. 

 

Multiline.PNG

 

 

Labels