Please help regarding "This cell has embedded newlines" error.

Hi there,

I have imported dataset from source excel file where one column is not showing all the character values in the alteryx workflow instead i see error saying "This cell has embedded newlines" can someone please advise how to get rid of this error?

screenshot attached for your reference.

Error screenshot.jpg

Help

Accepted answers

alexnajm

If you want to clean out the newlines, you could use a Data Cleansing tool or a Text to Columns tool (with a new line delimiter \n) depending on if you want to do anything to the data. Otherwise as @DataNath @mentioned this is more of a warning than an error - it just how your data is being stored!

All comments

DataNath

Hey @anonymous008_G this isn't an error as such i.e. it won't affect what's in the cell or cause your workflow to error - it's more just a warning that Alteryx isn't displaying everything in that cell in the browse anywhere view i.e. when you just click on the output of a tool. If you add a Browse tool to your workflow and then double click on the cell, you'll still be able to see everything that's held in it. Likewise when you write out to a DB or file or so on, everything will still be there!

alexnajm

anonymous008_G

Thank you Guys. This is helpful

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703