topic Re: Why is loading this CSV file generating nothing? in QlikView

Why is loading this CSV file generating nothing?

Fri, 03 Mar 2017 21:05:42 GMT

When I try to load this attached file in QlikView, after I click "Finish" and "ok on the "Edit Script", QlikView just becomes empty instead of displaying the data from the file. Why is this?

Re: Why is loading this CSV file generating nothing?

el_aprendiz111 — Fri, 03 Mar 2017 22:00:35 GMT

Hi,

Directory;
LOAD [Race/ethnicity],
Year,
[Rate of birth to women ages 18-19],
[Distribution of male children born to women ages 18-19],
[Distribution of female children born to women ages 18-19],
[Rate of birth to women ages 20-24],
[Distribution of male children born to women ages 20-24],
[Distribution of female children born to women ages 20-24]
FROM
[..\..\Documents\Downloads\ratebirth.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

Re: Why is loading this CSV file generating nothing?

vishsaggi — Fri, 03 Mar 2017 22:32:16 GMT

As Fer suggested just remove an extra space in [Race/Ethnicity] it should work.

Re: Why is loading this CSV file generating nothing?

Fri, 03 Mar 2017 23:49:48 GMT

I just used your script, but I still get nothing afterwards

Re: Why is loading this CSV file generating nothing?

Fri, 03 Mar 2017 23:50:10 GMT

I just remove the extra space, but I still get nothing afterwards

Re: Why is loading this CSV file generating nothing?

el_aprendiz111 — Sat, 04 Mar 2017 00:05:53 GMT

hi,

Re: Why is loading this CSV file generating nothing?

petter — Sat, 04 Mar 2017 09:55:04 GMT

It is obviously a bug. Which version of QlikView are you running? I am running QlikView 12.1 SR2. The others that have tried to help you might be running some version of QlikView that doesn't have this bug...

Solution#1: A work-around to be able to read your file could be:

LOAD 
  @1 AS [Race/ethnicity], 
     @2 AS Year, 
     @3 AS [Rate of birth to women ages 18-19], 
     @4 AS [Distribution of male children born to women ages 18-19], 
     @5 AS [Distribution of female children born to women ages 18-19], 
     @6 AS [Rate of birth to women ages 20-24], 
     @7 AS [Distribution of male children born to women ages 20-24], 
     @8 AS [Distribution of female children born to women ages 20-24]
WHERE
  RecNo()>1
;
LOAD 
  *
FROM

(txt, codepage is 1252, no labels, delimiter is ',');

Solution#2:

For a more dynamic solution that could be used for any table that has extra spaces at the end of any fieldname in a CSV:

TEMP:
LOAD * 
FROM 
(txt, codepage is 1252, no labels, delimiter is ',');

headers =  '';
FOR i=1 TO NoOfFields('TEMP')
  headers = headers & '@' & i & ' AS [' & Peek('@$(i)',0,'TEMP') & ']' & If(i<NoOfFields('TEMP'),',') ;
NEXT

RATEBIRTH:
LOAD $(headers)
RESIDENT TEMP
WHERE RecNo()>1;

DROP TABLE TEMP; headers=;i=;

Re: Why is loading this CSV file generating nothing?

swuehl — Sat, 04 Mar 2017 10:22:19 GMT

Mi Koll, could you be bit more specific what happens when you reload your script (I assume you actually performed a reload)?

Could you post a screen shot of the reload progress dialog or the document log you can enable in Settings - Document properties?

What does the table view (open with CTRL-T after reload) show?

Note that QV won't show any data in the front end until you add list boxes, charts, etc to the UI.

Re: Why is loading this CSV file generating nothing?

Sat, 04 Mar 2017 18:41:53 GMT

I'm using Qlikview 12.10 SR3''

I tried both of your solutions, and I still get nothing afterwards

Re: Why is loading this CSV file generating nothing?

Sat, 04 Mar 2017 19:04:40 GMT

after I hit Reload,I still get nothing. Attached are the reload progress and the table

Re: Why is loading this CSV file generating nothing?

swuehl — Mon, 06 Mar 2017 08:19:33 GMT

In table view, right click on the table and select 'preview'. What do you see?

Have you tried adding list boxes / table boxes in the UI?

Re: Why is loading this CSV file generating nothing?

jonathandienst — Mon, 06 Mar 2017 08:31:36 GMT

So the data loads fine, and as Stefan said - you need to create some front end objects(tables, list boxes, etc) to see the data.

Re: Why is loading this CSV file generating nothing?

sasiparupudi1 — Mon, 06 Mar 2017 08:38:42 GMT

Right Click on the sheet

Select New sheet object

select table box

add the dimensions to the box and click on OK. you should be able to see the data

hth

Sasi

Re: Why is loading this CSV file generating nothing?

priyasawant — Mon, 06 Mar 2017 08:41:37 GMT

Hi abcabc21 kindly open ur CSV file and remove the extra space after Race/ethnicity,

See in the below image.

Remove this space your data will be loaded properly and you can view it in the tabular form

Re: Why is loading this CSV file generating nothing?

petter — Mon, 06 Mar 2017 20:32:51 GMT

What do you mean that you get nothing? It could mean many things.

If you use the Table Viewer don't you get any tables there?

Do you get any error messages during the load script execution? What does the load script execution log show you while you're running it and at the end?

Could you share a couple of screenshots?