hi guys generic load with simple example? thanks

Thu, 06 Mar 2014 17:03:33 GMT

Re: hi guys generic load with simple example? thanks

fernando_tonial — Thu, 06 Mar 2014 17:06:38 GMT

Hi Manoj,

you can see a example in the QlikView Reference Manual.

27 Evaluating the Loaded Data.

27.1 Generic Databases.

Beste Regards.

Tonial.

alexandros17 — Thu, 06 Mar 2014 17:07:50 GMT

Esempi:

Differenti formati di file

Load * from data1.csv;

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

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

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

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 * from C:\qdssamples\xyz.qvx (qvx);

Selezionare alcuni campi, calcolare campi

Load FirstName, LastName, Number from data1.csv;

Load @1as A, @2 as B from data3.txt' (ansi, txt, delimiter is '\t', no labels);

Load FirstName&' '&LastName as Name from data1.csv;

Load Quantity, Price, Quantity*Price as Value from data1.csv;

Selezionare alcuni record

Load distinct FirstName, LastName, Number from data1.csv;

Load * from Consumption.csv where Litres>0;

Caricare dati non nel file

Load * Inline

[CatID, Category

0,Regular

1,Occasional

2,Permanent];

chiru_thota — Thu, 06 Mar 2014 17:08:18 GMT