Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

New Line in Data

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?

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: New Line in Data

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.


talk is cheap, supply exceeds demand
Highlighted

Re: New Line in Data

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

Highlighted
Partner
Partner

Re: New Line in Data

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?