topic Re: New Line in Data in Connectivity & Data Prep

New Line in Data

bbergstrom — Fri, 20 Jul 2018 15:31:04 GMT

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?

Re: New Line in Data

Gysbert_Wassenaar — Fri, 20 Jul 2018 16:29:15 GMT

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.

Re: New Line in Data

BalaBhaskar_Qlik — Sun, 22 Jul 2018 05:58:29 GMT

Try like:

Text(Field) as Field;

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

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

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

GROUP BY vField

Re: New Line in Data

bbergstrom — Tue, 24 Jul 2018 13:10:52 GMT

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?