New Line in Data

[bbergstrom]

In one of our SQL tables we have concatenated comments.  The SQL table is storing them correctly but when it is brought into a Qlik Sense table it is removing the Chr(10) and CHR(13):

SQL Table:

05/04/17 - Wheels is awaiting response from the vendor regarding your vehicle delivery.

05/04/17 - Order Cancelled

Qlik Sense Table:

05/04/17 - Wheels is awaiting response from the vendor regarding your vehicle delivery. 05/04/17 - Order Cancelled

Is there some other formatting options we can use?

[Gysbert_Wassenaar]

Try SET Verbatim = 1 in the script before loading the data. I'm not sure that will help. I don't think chr(10) and chr(13) are stripped out when loading the data. So it could be something else. Perhaps the table object ignores them.

[balabhaskarqlik]

Try like:

Text(Field) as Field;

OR

You could fill the field with spaces (chr(32)) in field, like

Field&repeat(chr(32),2-len(Field)) as Field,

OR

concat(Field1 & chr(10) & Field2) as NewField

GROUP BY vField

[bbergstrom]

Looking into it further this appears to be the case.  The table is showing the line returns removed but when you hover over the field the line returns are there.  I don't see a setting in the table viz to remove line breaks so is there some other way around this behavior?