Handling of New Lines in a cell While Performing CSV Writeback

[yas10]

Hi,

I have a writeback table, this table source is an excel file (.xlsx) which contains multiple values in a cell in a couple of columns (e.g. "a"\n"b"\n"c" without quotes). When writing this table into csv via vizlib writeback table it breaks the line e.g. after it detects line break after a it adds a new row starting from b.
I am seeking help with either of the 2 below:
1. table ignores line breaks when writing into csv and does not create a new row after line break
2. Entire row is duplicated (before and after column) for each line break

Thanks,

Yas

[marcus_sommer]

Before looking for a resolution you need to find the real cause. For this open the csv with an editor like Notepad++ and enable there the displaying of all chars. Is there already the unwanted line-break? If not - then is your issue caused from Excel interpretation-logic by opening the file.

[yas10]

Hi,

There was data in excel where in a cell of one of the columns used there was a new line data example as follows:

ABC
EFG

Basically I had to use replace function with ||| so that the rows would not break during writeback. Data above now is added as below in the table:

ABC|||EFG

Then I am doing reverse of above in load editor when loading the output table file in Qlik Dashboard (replace ||| with char(10)). 

Thanks for help!