topic Re: how to insert CSV file data into database using Qlikview script in QlikView

how to insert CSV file data into database using Qlikview script

Anonymous — Wed, 23 Dec 2015 06:33:52 GMT

Dear All,

Please share your ideas to insert data into oracle databse from csv file using QV script.

BR,

Chinna

Re: how to insert CSV file data into database using Qlikview script

jagan — Wed, 23 Dec 2015 06:39:39 GMT

HI,

Try like this

//Connection Sring

ODBC Connect to trDatabase;

//Load Data from Excel file

TABLE:

LOAD transaction_date,

location,

item,

site

FROM

[Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

// Getting number of records in Table

LET V_ROWS = NoOfRows('TABLE');

// Loop through the records and insert into Database table

FOR V_ROW = 0 TO V_ROWS - 1

LET V_FIELD1 = Peek('transaction_date',V_ROW);

LET V_FIELD2 = Peek('location',V_ROW);

LET V_FIELD3 = Peek('item',V_ROW);

LET V_FIELD4 = Peek('site',V_ROW);

SQL INSERT INTO dbo.temp_Table(transaction_date, location,item, site) VALUES('$(V_FIELD1)','$(V_FIELD2)', '$(V_FIELD3)','$(V_FIELD4)');

NEXT;

Regards,

Jagan.

Re: how to insert CSV file data into database using Qlikview script

jagan — Wed, 23 Dec 2015 06:39:55 GMT

Reference: Inserting records into Database using Qlikview Script

Regards,

jagan.

Re: how to insert CSV file data into database using Qlikview script

ashwanin — Wed, 23 Dec 2015 06:41:28 GMT

might be below thread help you :

Re: Can Qlikview write-back to an Oracle database?

Re: how to insert CSV file data into database using Qlikview script

jagan — Mon, 11 Jan 2016 05:45:47 GMT

Hi Chinna,

If you got the Answer please close this thread by giving Correct Answer.

Regards,

Jagan.

Re: how to insert CSV file data into database using Qlikview script

Anonymous — Thu, 14 Jan 2016 09:32:27 GMT

Hi Jagan,

I will test and mark accordingly.

Best Regards,

Chinna