Concatenate Files based on Key

[IgorGol]

Hi,

If I want to Concatenate two excel file based on : Key Column 

so if I have same field (with same key on both files I will not concatenate them) how can I do it in script?

For Example 

first excel file with column "key" and "values" : 1,2,3

second excel file with column "key" and "values" : 3,4,5

I want one column with column "key" and "values" : 1,2,3,4,5

Thanks!

[Lisa_P]

You can force concatenate using the concatenate prefix, but this is only advised when most if not all columns are the same.  Another option is to join the tables, what are you needing to do ?

[IgorGol]

Hi Lisa,

All my columns are the same 

How can I do it ? 

" You can force concatenate using the concatenate prefix" ?

Thanks!

[Lisa_P]

Before the Load statement use Concatenate(1stTableName) Load ...

Concatenate will append the data into one table, but you will get nulls for any fields not in other tables where they don't exist.