embedded newlines

[itahir04]

Hi Team,

I have a Cell with 4 values in it.

A	B
TestData	1.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:

A	B
TestData	1.0 Google
TestData	2.0 Yahoo
TestData	3.0 Amazon

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

Thanks,

Rana

[Thableaus · Accepted solution]

Hi @itahir04 

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

Cheers,

[Treyson]

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

[NickSm · Accepted solution]

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.

[itahir04 · Accepted solution]

Thank you So much!

[itahir04]

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

[Treyson]

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. 

[nlgenin]

Hello, my friend!

I'm have the same trouble although I need to do this with two columns, do you know how?