Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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 ?
Hi Lisa,
All my columns are the same
How can I do it ?
" You can force concatenate using the concatenate prefix" ?
Thanks!
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.