topic Re: Qlikview Data Source changes - Table name remains same in QlikView

Qlikview Data Source changes - Table name remains same

Wed, 25 Nov 2020 16:16:04 GMT

I've created a dashboard using Excel Files as a data source with table name Base

LOAD

A1,

C1,

FROM

[~\Data.xlsx]

(ooxml, embedded labels, table is Base);

Now I no longer receive new excel files, but CSVs. How do I change this to accept CSVs so that I can retain my tables and charts.

I tried giving Base as table name. But the views are showing no values

Base:

LOAD

A1,

C1,

FROM

[~\Data.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Any help?

Re: Qlikview Data Source changes - Table name remains same

ToniKautto — Mon, 05 Sep 2016 02:58:36 GMT

If you are not familiar with the LOAD syntax, I would suggest that you use the File Wizard. This will visually indicate what result you get based on the wizard selections you make.

The wizard can be found in the Script Editor (Ctrl + E) and the Data tab in the lower part of the window. The file wizard is triggered by the "Table Files..." button.

Re: Qlikview Data Source changes - Table name remains same

Siva_Sankar — Mon, 05 Sep 2016 03:01:08 GMT

use noconcatenate before the Base table script.

noconcatenate

Base:

LOAD

A1,

C1,

FROM

[~\Data.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Siva

Re: Qlikview Data Source changes - Table name remains same

jpenuliar — Mon, 05 Sep 2016 08:48:41 GMT

Have a look into Qlikview help:

Load ‒ QlikView

Example:

Loading different file formats

Load a delimited data file with default options:

LOAD * from data1.csv;

Load a delimited file, specifying comma as delimiter and with embedded labels:

LOAD * from 'c:\userfiles\data1.csv' (ansi, txt, delimiter is ',', embedded labels);

Load a delimited file specifying tab as delimiter and with embedded labels:

LOAD * from 'c:\userfiles\data2.txt' (ansi, txt, delimiter is '\t', embedded labels);

Load a dif file with embedded headers:

LOAD * from file2.dif (ansi, dif, embedded labels);

Load three fields from a fixed record file without headers:

LOAD @1:2 as ID, @3:25 as Name, @57:80 as City from data4.fix (ansi, fix, no labels, header is 0, record is 80);

Load a QVX file, specifying an absolute path:

LOAD * from C:\qdssamples\xyz.qvx (qvx);

Re: Qlikview Data Source changes - Table name remains same

Mon, 05 Sep 2016 08:51:44 GMT

I did use the LOAD Table Files feature, but that will give me the default file name of the csv as the Table name.

So, I gave "base" as the table name

Since it is the same table name as before, it should work right? But the dashboard comes up empty.

Re: Qlikview Data Source changes - Table name remains same

Thu, 06 Oct 2016 13:32:34 GMT

It was a date format issue guys. Since all of my charts were date based. They came up empty.

What I didn''t know was dates are read differently from Excel files and differently form CSV files, where source date format must be explicitly specified in the load statement.