How to join 2 tables with same column names with different data

[vanir88]

Hi All,

I have 2 tables like metadata1 , metadata2 which is having same columns

Ex:

contract no, submission date, dateflag,source,creation date from Metadata1 table

Join

Contract no, submission date,dateflag,source,creation date from metadata2 table

Where dateflag =0 and submission date

So how this 2 tables are getting join based on this where condition ot with default join out. Can one please help me on this.

[rwunderlich · Accepted solution]

Because these are additional rows, you should be using Concatenate instead of Join.

MyTable:
Load contract no, submission date, dateflag,source,creation date from Metadata1... 

Concatenate (MyTable)
Load contract no, submission date, dateflag,source,creation date from metadata2...

-Rob