Data import from Excel is incomplete

[sahartz]

Hi All,

Would appreciate your help. I am using the input tool to input data from Excel file, but some of the data is cut.

for example:

Original data in excel: 

To xx with XX XX XX and XX XX requirements, XX operates an XX procedure and customers are entitled to request XX to delete applicable data about them XX XX by laws, regulations and terms and conditions.

A review of the XX procedures identified several discrepancies, including:
1. sfsfsfsfsfxvcxvxvsvxvs
2. sdfsfsfsdfsfsdfsfsfsfsdfsdf.
3. sdfsdfsffgtdtrwvxcvxvsfwet
4. gdfgdsgdfgdfgdgdfgdfgdgdgdg

After importing the data to Alteryx, via the Input tool, the data I see is: 

To xx with XX XX XX and XX XX requirements, XX operates an XX procedure and customers are entitled to request XX to delete applicable data about them XX XX by laws, regulations and terms and cond...

Input tool parameters are:

Could you pls LMK how to solve this issue?

[Yoshiro_Fujimori]

@sahartz ,

Not knowing the root cause of the issue, if you see the notification "This cell has embedded new lines ...", 

it seems that Alteryx is recognizing the newlines characters.

Could you try Text-To-Columns tool with Delimiter "\n" with "Split to Rows" option?

If that works, you may be able to rebuild the multi-row cells with Summarize Tool as below.

Sample workflow