Struggling with Concatenate Join Keep Choices

[Clairezeepoos]

Hi All,

I'm struggling to append data from one table to another and getting strange results because the first two fields have the same values in both tables.

Below are two sample tables and table 3 shows the required output that Table one should end up as.

Table 1
KPI	DateKey	Class	Value
KPI1	mm01	Actual	0.45
KPI1	mm02	Actual	0.34
Table 2
KPI	DateKey	Class	Value
KPI1	mm01	Target	0.55
KPI1	mm02	Target	0.49
Table 1 after load
KPI	DateKey	Class	Value
KPI1	mm01	Actual	0.45
KPI1	mm02	Actual	0.34
KPI1	mm01	Target	0.55
KPI1	mm02	Target	0.49

Any pointers would be gratefully received

Claire

[JustinDallas]

How are they ending up?  And do the source tables both have the same field list?

[stevejoyce]

Please share your script and details on what is strange.  These tables would automatically concatenate if you aren't using noconcatenate or qualify, since they have the same field names.  

Concatenate ([Table 1])

Load *

Resident [Table 2]

;

drop table [Table 2]

[Clairezeepoos]

Hi All,

I have since resolved this issue thankyou for all input.

Claire