Merge two incrementaly load table

Fri, 27 Jan 2012 08:52:00 GMT

Hello,

I have two database table that I want load incrementally each days. I have already use incremental qvd process to load the two tables using a classic Auto Incremant primary key an a filed UpdateDate on each database table.

But I want now merge these tables in one QlikView table. For information I must do incremental load with QVD files because I have more than 30 000 000 lines in my tables updtated each days, so all lines reload take too much time.

The table are like this:

Table A:

PKAutoIncremented

UpdateDate

FieldA

FieldB

Table B:

PKAutoIncremented

UpdateDate

FieldA

FieldB

I want this:

TableC:

FieldA+'-'+FieldB

And only different FieldA-FiledB Values in the table because I want use it as a referential inside QlikView and use the field FieldA-FiledB for auto join with another table.

I attempt to Load incrementally the Table A whith a first QVD in a table "referential", then the Table B on another QVD in a table "TmpReferential".

After it I want merge the two table for delete duplicated synthetic keys (FieldA+'-'+FieldB)

I am not sure if synthetic keys FieldA+'-'+FieldB could be processed correctly, I defined it in SQL query part, and use the true primary key of each database table for incremental loads. I know Synthetic keys aren't stored in Qvd.

I think it's possible with some JOIN clause, but in my tests I have issues on final QlikView table mapping with an other table on my synthetic key (all unmatched. Or perhaps duplicate values which create error on mapping?).

With only the first table A no mapping or incremental load problem. When I attempt to merge two table A and B I have no mapping.

Could you help me.

Thanks.

Merge two incrementaly load table

Fri, 10 Feb 2012 10:47:36 GMT

Hello,

After many try, I haven't solved this mapping/merging issue.

With Ctrl+T command I see that th QlikView merged tables result display only NULL value on the synthetic key FieldA+'-'+FieldB

Consequently I merged my tables directly in database and use an autoincrement Primary key on the result table as key for the auto increment Load procedure.

It solved it.

Regards.

Merge two incrementaly load table

perumal_41 — Fri, 10 Feb 2012 11:09:42 GMT

Hi,

use this expression in Ur Script

FieldA&'-'&FieldB

Regards,

Perumal A

topic Merge two incrementaly load table in QlikView

Merge two incrementaly load table

Merge two incrementaly load table

Merge two incrementaly load table