This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I imported an xlsx into Alteryx, there is column of cells contains a lots of new line format. I tried to use data cleansing to delete it. It was successful however, it it leave a gap where the new line was e.g
FYI when you share workflows (.yxmd), it does not include the dependencies like the Excel file. You could either attach the Excel file separately, or export the workflow (Options>Export Workflow) which will include the Excel file in a compressed Alteryx format.
Until we can test with the actual data, here's something to try:
You could use a Regex_Replace() function to remove the line breaks. I've used the following function inside a multi-field formula to perform the function on all fields at once. Then combining the columns using the formula tool.
REGEX_Replace([_CurrentField_], '\n', '')
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.