topic Re: Loading the matched records in QlikView

Loading the matched records

sharankv — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Loading the matched records

Anil_Babu_Samineni — Mon, 26 Sep 2016 15:53:17 GMT

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;

Re: Loading the matched records

sunny_talwar — Mon, 26 Sep 2016 16:17:56 GMT

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