Button->properties->Actions->Dynamic update->SQL INSERT INTO ??

[#1]

Hello i'll like to know if is that possible ?? (i'm french and my qlikview is in french so i don't know english word)

Button->properties->Actions->Dynamic update-> ( and here do "SQL INSERT INTO table_name (column_name) VALUES (name_value); )

that work in qlikview script but i need it, in this button ^^ if you have if you have syntax that interested me.

I working on error log file (.txt) and I trying to create a module which can extract desired information through QlikView.

[#2]

Yes, dynamic update can be used for inserting values in to a table.

Use this syntax;

insert into Table_Name(Field_Name) values('Value needs to be inserted')

Thanks,

Anoop

[#3]

Hi Anoop,

I have tried the mentioned syntax and Values are not getting inserted to the field.

Could you please elaborate bit in detailed.

Thanks in Advance.

Rajesh.

[#4]

Hi Rajesh,

Please refer the attached sample document.

Thnaks,

Anoop

[#5]

Hi Anoop,

It was really gud and could you please explain how you have taken this:

Fruits:

LOAD Name

FROM

Dyn.xlsx

(ooxml, embedded labels, table is Fruits);

[#6]

Hi Rajesh,

I am just loading 3 rows of data using the load script. Remaining data has been added through dynamic update statement written in the text object action. Please check the Action written in the text object.

Please let me know if this helps.

Thanks,

Anoop