Skip to Content
0
Former Member
May 08, 2014 at 01:44 PM

Creation of View from Mutiple Tables (Union of result sets)

230 Views

Hi,

I have started working on Information Steward very recently and Im working on creating some profiling rules in Data Insight.

I’m working on bringing data in two tables together to apply some common rules, I have tried view option but I’m not sure how to create the views as below without joins.

View should have common columns from Table1 and Table2 so I can perform below rules.

  1. Check uniqueness of primary key column across both the tables. Like Id – Unique in view below
  2. Combination of two different columns should be unique in both the tables. Like First name + Last Name Unique in view

I would like to create a view which is can be done using Aggregator in Information PC and Merger in BODS.

Permenent Employee

Id

First Name

Last Name

Age

salary

6

Sachin

Tendulkar

41

2000

7

Ajay

Jadeja

43

2000

9

Rahul

Dravid

40

2000

Contracting Employee

Id

First Name

Last Name

Age

salary

1

Sourav

Ganguly

41

2000

2

Ajith

Agarkar

38

2000

3

Anil

Kumble

43

2000

View

Id

First Name

Last Name

Age

salary

1

Sourav

Ganguly

41

2000

2

Ajith

Agarkar

38

2000

3

Anil

Kumble

43

2000

6

Sachin

Tendulkar

41

2000

7

Ajay

Jadeja

43

2000

9

Rahul

Dravid

40

2000

Please let me know you thoughts on how this can be achieved in SAP IS