topic How to create and append to a CSV via QlikView script in QlikView

How to create and append to a CSV via QlikView script

Wed, 09 May 2012 09:34:48 GMT

Hi All,

I wanted to know how would I (if possible) write to a CSV file in the QlikView Script and append to that file every reload thats done.

Example:

STORE "SomeDataTable" INTO "CSVDump.txt" (txt); //But the next time the reload happens the data in "SomeDataTable" must be appended to the CSV File

Thanks in advance,

Krisen

Re: How to create and append to a CSV via QlikView script

Miguel_Angel_Baeyens — Wed, 09 May 2012 09:51:12 GMT

Hi Krisen,

There is no such statement as "APPEND" but you can do a two step load / store that will keep your old information besides the new records. Take a look at the following example:

SomeDataTable: // already existing records in your CSV file
LOAD *
FROM CSVDump.txt (options here);
NewRecords: // With same structure, field names and number of fields as in the table above
CONCATENATE (SomeDataTable) LOAD *
FROM NewData;
// Now the table "SomeDataTable" has both old and new rows
STORE "SomeDataTable" INTO "CSVDump.txt" (txt);

Hope that helps.

Miguel

How to create and append to a CSV via QlikView script

jvitantonio — Wed, 09 May 2012 09:51:46 GMT

Hi, refer to help as "Incremental Reload"

Re: How to create and append to a CSV via QlikView script

its_anandrjs — Wed, 09 May 2012 09:53:19 GMT

Hi,

I suggest go for incremental load for the data and then make the csv.

Regards,

Anand

Re: How to create and append to a CSV via QlikView script

Wed, 09 May 2012 12:24:31 GMT

Thanks guys for the guidance, i will have a look into the solutions.

The "source" data is actually a timestamp, one before loading and one after loading completes.

So in essence:

PSEUDO:
SET startTime = <timestamp>
STORE startTime to CSV
LOAD DATA
SET endTime = <timestamp>
Incremental Store endTime to CSV

Making sense?