-
Re: Rows Miss information
Gysbert Wassenaar Sep 28, 2016 1:23 PM (in response to Salamon Musayev)Can you post a small excel file that gives this kind of result when you try to load it in Qlik Sense?
-
Re: Rows Miss information
Salamon Musayev Sep 28, 2016 1:42 PM (in response to Gysbert Wassenaar )Hi
The TESTS4QLIK is the file that is being exported from SQL
InQlikTest is the export of what QLIK shows me after I import TESTS4QLIK
Hope this helps,
Thank you,
-
InQlikTest.xlsx 9.3 K
-
TESTS4QLIK.xlsx 8.0 K
-
Re: Rows Miss information
Gysbert Wassenaar Sep 28, 2016 1:58 PM (in response to Salamon Musayev)Well, I don't know what you're doing exactly or which version of Qlik Sense you're using. But your excel file loads perfectly fine in Qlik Sense 3.1 over here. So, sorry, but no idea.
-
c234556.qvf 176.0 K
-
Re: Rows Miss information
Salamon Musayev Sep 28, 2016 3:37 PM (in response to Gysbert Wassenaar )I found what causing the issue.
In the column tests, there are several test that have a 'comma' in the row.
When Qlik imports the xlsx file it sees the comma as a separator. The reason why you and Lakshmikandh were able to load is because you did not have the full file with many other additional columns. I rearranged the column to be the last column in the table and it loaded perfectly.
Have you come across something like this before where a comma or the position of the column makes a difference in the way the data gets loaded?
If yes, is there a different solution.
-
-
Re: Rows Miss information
Lakshmikandh Karthikeyan Sep 28, 2016 1:59 PM (in response to Salamon Musayev)Hi,
With the given file i am able import and export from Qlik as well with full values.
Attached the sample app
-
testt.qvf 176.0 K
-
Re: Rows Miss information
Salamon Musayev Sep 28, 2016 3:37 PM (in response to Lakshmikandh Karthikeyan )thank you
-
-
-