Concatenate or Union

[#1]

I have two excel files, one for 2009 and one for 2008. They have identical field names. I want to merge the two tables into one table in the load script. How do I do this?

Thanks,

Stephen

[#2 · Accepted solution]

If you load two excel (or any) files with exactly the same fields, they will automatically exist in a single table in QV. Two differentiate between the years I suggest something like this:

LOAD

'2008' as Year,

... excel load here...

FROM excel.xls

then do

LOAD

'2007' as Year,

... excel load here ...

FROM excel2.xls

[#3]

I tried what you noted but it loads as two separate tables. In other words one fields called "Amount" in both tables loads with two different fileds. One as 2008.Amount and one as 2007.Amount, I only want an Amount field.

Stephen

[#4]

Further detail. It works (so far) I was initially using Qualify and Unqualify which created the separate tables.