topic how to insert,update and delete Record from to database table from inline load statement of qlikview script in QlikView

how to insert,update and delete Record from to database table from inline load statement of qlikview script

debabrata_sahoo — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

My requirement is insert,update and delete record of inline section accesses to database while loading.

example : what ever I do change in inline section accesses script it will reflect to database table.

Please help on this scenario.

Thanks,

Debabrat

Re: how to insert,update and delete Record from to database table from inline load statement of qlikview script

tresB — Thu, 16 Aug 2018 06:11:08 GMT

Inserting records into Database using Qlikview Script

Re: how to insert,update and delete Record from to database table from inline load statement of qlikview script

debabrata_sahoo — Thu, 16 Aug 2018 06:36:58 GMT

it asking to join group..

Re: how to insert,update and delete Record from to database table from inline load statement of qlikview script

tresB — Thu, 16 Aug 2018 07:03:03 GMT

Let me get the content here:

Hi,

The below script helps to insert data from Qlikview to Database using Script.

//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.