Update data into database

Sun, 08 Jun 2014 12:11:42 GMT

Hello everyone,

I want to update a data in the database, overwriting it. But my problem is: I don't want to overwrite a field WITH VALUES with a NULL value. I want to retain the value in a certain field if my update contains null. I am using EXPRESSOR.

Ok here is an example to show you what I meant:

Assuming this is the existing value in the database:

ID	Name	Address	Phone	Sales	Area	Date
1	Reagan	lindenweg 6	123456	1000	Seewil	12/31/2012

And I want to update that with these data using ID field as the key:

ID	Name	Address	Phone	Sales	Area	Date
1				800		1/23/2013

I want my result to be like this:

ID	Name	Address	Phone	Sales	Area	Date
1	Reagan	lindenweg 6	123456	800	Seewil	1/23/2013

I have tried UPDATE MODE in "Write Table Operator" in Expressor but old values are overwritten with NULL values. Can you help me on this? Thanks a lot.

Re: Update data into database

Sun, 08 Jun 2014 20:42:19 GMT

I dont have to many experiences with expresasor, but in other etl tools this kind of cdc needs rather to read both tables, join old with new rows, checking if update is needed calculating new fields values and then updating DB.

regards

Darek.

topic Update data into database in QlikView

Update data into database

Re: Update data into database