Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to connect to a table in SQL server. Create changes to that table in Qlikview and save those changes back to the SQL Server table?
NO
if an Extension is an option
SQL Writeback from QlikView extension object.
Yes using a macro or JS extension, but its iffy practice at best
LET V_ROWS = NoOfRows('Item_Requirements');
//exit script;
// Loop through the records and insert into Database table
FOR V_ROW = 0 TO V_ROWS - 1
LET V_FIELD2 = Peek('Item',V_ROW);
LET V_FIELD3 = Peek('Language',V_ROW);
LET V_FIELD4 = Peek('Description',V_ROW);
LET V_FIELD5 = Peek('Sequence',V_ROW);
//Invoegen in SQL
SQL INSERT INTO [DateBase].dbo.table(Item, Language, Description, Sequence)
VALUES('$(V_FIELD2)', '$(V_FIELD3)','$(V_FIELD4)','$(V_FIELD5)');
NEXT;
Thanks so we need to learn Window communication foundation when we face this scenario.