Qlikview Data Source changes - Table name remains same

[#1]

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

LOAD

     A1,

     B1

     C1,

     D1

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,

     B1

     C1,

     D1

FROM

[~\Data.csv]

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

Any help?

[ToniKautto]

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.

[Siva_Sankar]

use noconcatenate before the Base table script.

noconcatenate

Base:

LOAD

     A1,

     B1

     C1,

     D1

FROM

[~\Data.csv]

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

Siva

[jpenuliar]

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);

[#5]

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.

[#6]

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.