Loading the matched records

[sharankv]

I have two tables namely Payments and Disease Area.

Payments table has 65 fields. Some of them are:

Payments:

Company,

Brand,

Revenue,

Date

..........;

Disease Area table has 4 fields such as:

Disease Area:

Company,

Brand,

Disease Area,

Theraupetic Area;

In my data, I have more Company distinct values in Payments table when compared to the Company field distinct values in Disease Area table.

My requirement is to load only the records for which the Company values are common in both the tables.

Please come up with the answers

Thanks

Sharan

[Anil_Babu_Samineni]

You can try with Inner Join

Payments:

Company,

Brand,

Revenue,

Date

..........;

Inner Join(Payments)

Disease Area table has 4 fields such as:

Disease Area:

Company,

Brand,

Disease Area,

Theraupetic Area;

[sunny_talwar]

You can use Keep statement (inner or Left/Right Keep) in case you don't want to join them for any reason.

Understanding Join, Keep and Concatenate