Gsheet text with blank "enter" rows within one cell not showing

[#1]

Hello,

I have a qlikview app which reads data from a google spreadsheet using QlikWebConnectors. This sheet is a translation table for multiple languages so it sometimes contains long text strings in one cell.

An example of the sheet data:

English	Dutch	German
one	een	ein
Text Text Text Best Regards	Tekst Tekst Tekst Met vriendelijk groet	Tekst Tekst Tekst Mit freundlichen Grüßen

As you can see the second row consists of text with blank rows. These rows are not loaded into qlikview and the field comes up like this:

Text

Text

Text

Best Regards

We did not have these problems when we loaded this table from excel. Any ideas how to fix this (we want to keep working with Gsheet)

Regards,

Peter

[Anil_Babu_Samineni]

Qlikview consider and retrieve only unique keys. You must reload like below then null or distinct rows should come

Load *, RowNo() as UniqueKey;

Note - UniqueKey returns and retrieve all records.