topic Re: How to append data from table A to table B? in QlikView

How to append data from table A to table B?

Mon, 27 Apr 2015 08:47:05 GMT

Hi there,

I need to maintain a daily report database, which contains 2 identical structure tables, one table to save historical data, another table to save previous day data.

I want to realize function as following:

1.Check whether the historical data include data for the previous day.

2.If the previous day's data are missing, then added to the historical data table.

Thank you in advance!

Re: How to append data from table A to table B?

NareshGuntur — Mon, 27 Apr 2015 08:53:13 GMT

Bing,

You should first identify the Primary Key in the table. Use exists function to identify whether the previous day data is in historical or not. Hope it is clear.

Best Regards,

Naresh

Re: How to append data from table A to table B?

buzzy996 — Mon, 27 Apr 2015 08:56:44 GMT

I think u can use here,Incremental load concept.

Re: How to append data from table A to table B?

NareshGuntur — Mon, 27 Apr 2015 08:57:37 GMT

A correction

You should first identify the Primary Key in the table. Use exists function on the primary key field to identify whether the previous day data is in historical or not. Hope it is clear.

Best Regards,

Naresh

Re: How to append data from table A to table B?

hariprasadqv — Mon, 27 Apr 2015 09:00:00 GMT

use exists function if perfect key is found else use date field.